DSN Option for Native Large Object Support - ODBC Driver for Teradata

ODBC Driver for Teradata User Guide

Product
ODBC Driver for Teradata
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

The ODBC driver currently has the option to enable and disable Large Object (LOB) data types. When enabled (UseNativeLOBSupport in odbc.ini and Use Native Large Object Support in the DSN setup dialog), SQL_LONGVARBINARY ODBC data type maps to the Teradata Binary Large Object (BLOB) feature, and SQL_LONGVARCHAR maps to the Teradata Character Large Object (CLOB) feature.

The default setting has been changed from no to yes. It is strongly advised to retain the default setting for Native Large Object (LOB) data types, because the option will be removed in a future release.