ANSI ODBC Applications - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
16.20
Published
August 2020
Language
English (United States)
Last Update
2020-08-25
dita:mapPath
fxv1527114222338.ditamap
dita:ditavalPath
Audience_PDF_product_legacy_odbc_include.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

In the following section, assume that the ANSI application is limited to SQL_C_CHAR data binding and a non-Unicode session character set is used. The following figure depicts the programming model for ODBC Driver for Teradata:



  1. SQL-Text and SQL_C_CHAR character data flows between the ODBC Application and the ODBC Driver Manager
  2. The ODBC Driver Manager:
    • Converts the SQL-Text to Unicode and passes it to the ODBC Driver
    • Does not convert the SQL_C_CHAR data and passes it as is to the ODBC Driver
  3. The ODBC Driver for Teradata Database:
    • Converts the SQL-Text from Unicode to Session Character Set
    • Does not convert the SQL_C_CHAR data and passes it as is to Teradata Database