15.10 - ODBC SQL Character Data Types - ODBC Driver for Teradata

ODBC Driver for Teradata User Guide

prodname
ODBC Driver for Teradata
vrm_release
15.10
category
User Guide
featnum
B035-2509-035K

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.