ODBC SQL Character Data Types - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
17.10
Published
October 2021
Language
English (United States)
Last Update
2021-11-02
dita:mapPath
wxs1608578396899.ditamap
dita:ditavalPath
nkw1500504256726.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.

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 Teradata Vantage™ - Advanced SQL Engine International Character Set Support, B035-1125.