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 following table:
| 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 ODBC Driver for Teradata. 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. |