Reports LOBs as long data types or as large object types.
This option indicates to CLI what data type the application expects when working with a database with large object (LOB) columns.
Database data type | Large objects (0 - Default) | Long data types (1 - CLI/ODBC; 2 - JDBC) |
---|---|---|
CLOB | SQL_CLOB | SQL_LONGVARCHAR |
BLOB | SQL_BLOB | SQL_LONGVARBINARY |
DBCLOB | SQL_DBCLOB | SQL_LONGVARGRAPHIC* |
* If the MapGraphicDescribe keyword is set in conjunction with LongDataCompat, DBCLOB columns will return an SQL type of SQL_LONGVARCHAR if MapGraphicDescribe is 1 and SQL_WLONGVARCHAR if MapGraphicDescribe is 2. |
This option is useful when running ODBC applications that cannot handle the large object data types.
The CLI/ODBC option LOBMaxColumnSize can be used in conjunction with this option to reduce the default size declared for the data.