The ODBC specification supports six SQL character data types while Teradata supports three character data types. Table 40 shows how ODBC Driver for Teradata maps the Teradata character data type to ODBC SQL data types.
Teradata Data Type |
ODBC SQL Data Type |
ODBC SQL Data Type |
CHAR |
SQL_CHAR |
SQL_WCHAR |
VARCHAR |
SQL_VARCHAR |
SQL_WVARCHAR |
CLOB |
SQL_LONGVARCHAR |
SQL_WLONGVARCHAR |
For additional information, see “Application Model With Single Form-of-Use” in International Character Set Support.