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.