15.10 - KANJI932_1S0 - Teradata Database

Teradata Database International Character Set Support

prodname
Teradata Database
vrm_release
15.00
15.10
category
Configuration
User Guide
featnum
B035-1125-015K

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

“JIS X 0201” on page 151.

the JIS X 0208 standard

“JIS X 0208” on page 153.

the Shift-JIS encoding

“Shift-JIS (DOS Kanji) Encoding” on page 165.