17.20 - SQLGetTypeInfo - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2022-06-21
dita:mapPath
uqj1639470627591.ditamap
dita:ditavalPath
nkw1500504256726.ditaval

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.

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