Determines whether the driver enforces native LOB data type mapping.
Valid Values
1 | 0
Behavior
If set to 1 (Enabled), the driver enforces native LOB data type mapping as described:
ODBC data type SQL_LONGVARBINARY is mapped to the Teradata BLOB feature.
ODBC data type SQL_LONGVARCHAR is mapped to the Teradata CLOB feature.
If set to 0 (Disabled), the driver provides backward compatibility for applications without LOB support that are using a version of Teradata Database prior to V2R5.1. The mappings are:
ODBC data type SQL_LONGVARBINARY is mapped to the Teradata VARBYTE(32000) feature.
ODBC data type SQL_LONGVARCHAR is mapped to the Teradata LONG VARCHAR feature.
This value can improve performance if your application does not send data to, or retrieve it from, LOB columns. You may receive an error if you disable this option and try to retrieve data from a LOB column.
ODBC data type SQL_LONGVARBINARY is mapped to the Teradata BLOB feature.