ODBC SQL Character Data Types - ODBC Driver for Teradata

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.

Table 40: ODBC SQL Character Data Types 

Teradata Data Type	ODBC SQL Data Type Non-Unicode Session Character Set	ODBC SQL Data Type Unicode Session Character Set
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.