SQLGetTypeInfo

ODBC Driver for Teradata® User Guide

prodname
ODBC Driver for Teradata
vrm_release
16.20
category
User Guide
featnum
B035-2526-108K

SQLGetTypeinfo returns information about a specified ODBC data type. It may also return information about SQL_ALL_TYPES, in which case it returns information about all the ODBC data types.

The LOB related information depends on whether or not LOB Support is available. LOB Support is available when the database supports the LOB feature.

The option to set Native LOB Support is deprecated. For details, see Deprecated SQL Transformations.

If LOB Support is available, when SQLGetTypeInfo is called with SQL_ALL_TYPES, SQL_ALL_TYPES will include information about the SQL_LONGVARBINARY or SQL_LONGVARCHAR data types.

If LOB Support is not available, then SQL_ALL_TYPES will not include information about the SQL_LONGVARBINARY or SQL_LONGVARCHAR data types.

When SQLGetTypeInfo is called with either SQL_LONGVARBINARY or SQL_LONGVARCHAR, it will return information about these data types. See the table that follows.

LOB Support Available SQL_ALL_TYPES includes LONG data types SQL_LONGVARBINARY maps to SQL_LONGVARCHAR maps to
Yes Yes BLOB CLOB
Yes Yes VARBYTE(3200) LONG VARCHAR