The Teradata ODBC Driver requires the following setup for use against databases with Japanese and UTF-8 encoding:
I. ODBC driver installation for Windows
First, install GSS Client and ICU Libraries. Then, install the ODBC driver.
II. DSN Setup for the Teradata driver on Windows
The default "Session Character Set" is set to ASCII. The DSN Session Character Set should be changed to the value as shown in the table below (WH stands for warehouse and MD for metadata):
1 Byte | 1 Byte | 1 Byte |
1 Byte | 1 Byte | 1 Byte |
1 Byte | 1 Byte | 1 Byte |
III. DSN setup for the Teradata driver on Unix
In the odbc.ini file, add "CharacterSet=UTF8" in Teradata DSN for Japanese (KANJISJIS_0S) WH and UTF8 MD/WH. The CharacterSet should be changed to the value as shown in the table below:
1 Byte | 1 Byte | 1 Byte |
1 Byte | 1 Byte | 1 Byte |
1 Byte | 1 Byte | 1 Byte |
Third Party Software Installation:
WARNING:
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.
