KANJI932_1S0 character set is based on Windows Code Page 932. It emulates the Shift-JIS style of mixed single- and multibyte character data, where the range of the first byte in a character determines if the character is represented as one byte or two bytes.
The KANJI932_1S0 character set includes all the characters in the JIS X 0201 and JIS X 0208 standards, plus extensions. Supported characters include single-byte Hankaku Katakana characters and multibyte Kanji characters.
The character mapping tables are described in the following text files, which are available on CD and on the Web at http://www.info.teradata.com/.
File Name (on CD) |
Title (on the Web) |
Description |
K1S0SUCD.txt |
KANJI932_1S0 Single Byte to Unicode |
Maps KANJI932 to Unicode. |
K1S0MUCD.txt |
KANJI932_1S0 Multibyte to Unicode |
Maps the multibyte character portion of KANJI932 to Unicode. |
Object names on systems enabled with Japanese language support can contain single-byte Latin and Katakana characters from the JIS X 0201 standard, and double-byte characters from the JIS X 0208 standard.
The valid ranges for JIS X 0201 and JIS X 0208 characters in KANJI932_1S0 object names appear in “Shift-JIS Encoding” on page 165. Characters in the reserved regions of the JIS X 0208 standard are not allowed.
Gaiji characters with first byte values 0xF0-0xF9 and IBM characters with first byte values 0xFA-0xFC are not allowed in object names. Additionally, some characters that are valid in JIS X 0208 do not map to the KanjiEBCDIC encoding and are not valid in KANJI932_1S0 object names. The following table provides a complete list of multibyte character codes that are not valid for object names under the KANJI932_1S0 character set.
First Byte |
Second Byte |
|
0x81 |
0x40 - 0x49 |
0x4C - 0x50 |
0x52 - 0x5A |
0x5C - 0x8F |
|
0x91 - 0x93 |
0x95 - 0xFC |
|
0x83 |
0x9F - 0xFC |
|
0x84 |
0x40 - 0xFC |
|
0xEA |
0xA3 - 0xA4 |
|
0xF0 - 0xFC |
0x40 - 0x7E |
0x80 - 0xFC |
For details on the rules and restrictions for naming Teradata Database objects, see SQL Fundamentals.
For more information on … |
See … |
the JIS X 0201 standard |
|
the JIS X 0208 standard |
|
the Shift-JIS encoding |