Large Object Data Types

Learn about the characteristics of the large object LONG BINARY and LONG VARCHAR data type columns and index support of large object data.

• Large Object Data Types LONG BINARY and BLOB
  Binary large object (BLOB) data in SAP Sybase IQ is stored in columns of data type LONG BINARY or BLOB.
• Large Object Data Types LONG VARCHAR and CLOB
  Character large object (CLOB) data in SAP Sybase IQ is stored in columns of data type LONG VARCHAR or CLOB.
• Large Object Variables
  SAP Sybase IQ supports large object variables.
• Index Support of Large Object Columns
  SAP Sybase IQ supports the TEXT index on LONG BINARY and LONG VARCHAR columns, and the WORD (WD) index on LONG VARCHAR columns.