Try OpenEdge Now
skip to main content
SQL Reference
SQL Reference : OpenEdge SQL Language Elements : Data types : Bit string data types : CLOB limitations
CLOB limitations
Current limitations for BLOB support are as follows:
*CLOB data columns cannot be part of an index.
*CLOB data columns cannot be used for variables or as parameters in stored procedures.
*Comparison operations are not supported on CLOB columns. Comparison operations between CLOB columns are not supported. Comparison operations between CLOB columns and columns of other data types are not supported.
*The LIKE predicate is supported for CLOB columns.
*Conversion, aggregate, and scalar functions are disallowed on this data type.
*The default size for a CLOB is 32000 bytes.