17.10 - Choosing a Name for a Chinese Multibyte Character Set - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine International Character Set Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
User Guide
Publication ID
B035-1125-171K
Language
English (United States)

If the Teradata-defined Chinese character sets described in Chinese Character Sets are not appropriate for your site, you can define your own character sets using the following names, IDs, and encodings.

Character Set Name ID Description
SDSCHEBCDIC935_6IJ 75 Simplified Chinese for mainframe clients.

The encoding form is EBCDIC Shift-Out/Shift-In, where the shift-out character 0x0E and shift-in character 0x0F bracket zero or more double-byte characters.

SDTCHEBCDIC937_7IB 76 Traditional Chinese for mainframe clients.

The encoding form is EBCDIC Shift-Out/Shift-In, where the shift-out character 0x0E and shift-in character 0x0F bracket zero or more double-byte characters.

SDSCHGB2312_2T0 94 Simplified Chinese for network-attached clients.

The encoding form is Extended UNIX Code (EUC), composed of two code sets: cs0 for single-byte characters and cs1 for double-byte characters.

SDTCHBIG5_3R0 95 Traditional Chinese for network-attached clients.

The value of the first byte in a sequence distinguishes single-byte characters from double-byte characters.

The system uses the two characters following the underscore (_) in the character set name as a link to the mapping file you create in the TPA etc or TPA cfg directory. The name of the mapping file must start with “map_” and end with the first two characters following the underscore in the character set name.

For example, if you define a character set for SDTCHBIG5_3R0, you must create a mapping file named map_3R that provides the translation tables between the transitional forms and Unicode.