16.20 - Session Character Sets and Translation DLLs - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

ODBC Driver for Teradata
October 2018
User Guide

The following table indicates SQLDriverToDataSource conversions. The subsequent table describes SQLDataSourceToDriver conversions. UTF8/UTF16 session character sets do not require translation DLLs.

Function of SQLDriverToDataSource
Convert Windows application code page to UTF16

The following table describes the functions of the SQLDataSourceToDriver.

Function of SQLDataSourceToDriver
Convert UTF16 to Windows application code page

User-defined session character sets can be used either with or without a translation DLL. If no translation DLL is specified, the driver's conversion is based on the current application code page. With Teradata-provided session character sets, no translation DLLs are needed as long as the session character set matches to the current application code page. For example, a Chinese session character set matches the Chinese Windows PC.

It is recommended translation DLLs be copied to the same folder and location where the driver was installed.

KANJIEBCDIC5038_0I is supported on Windows systems when set up as a Japanese machine (CP932). Other configurations are not supported. This character set is used for communications to and from the database. The application must use the Windows CP932 session character set when communicating with the ODBC driver. This behavior is identical to KANJIEUC_0U.