The ODBC specification supports six SQL character data types while Teradata supports three character data types. The following table shows how ODBC Driver for Teradata maps the Teradata character data type to ODBC SQL 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 (B035-1125).