SQLGetTypeInfo

ODBC Driver for Teradata® User Guide

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

The result set returned by SQLGetTypeInfo has an additional Teradata ODBC-specific column after the standard columns. The specific column information is listed in the table below.

Column Name Column Number (ODBC 3.X) Data Type Comments
USER_DATA_TYPE 20 Smallint Always NULL
TDODBC_ DATA_TYPE 21 Smallint not NULL Teradata ODBC-specific SQL data type code used by the ODBC driver. If multiple database types have the same standard ODBC SQL type, then the Teradata ODBC-specific SQL data type code can be used to distinguish between the types. For an example, see Number Data Types.