SQLGetTypeInfo - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-25
dita:mapPath
fxv1527114222338.ditamap
dita:ditavalPath
Audience_PDF_product_legacy_odbc_include.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

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