KANJISJIS_0S - Teradata Database

KANJISJIS_0S is provided for PC platforms running Windows, and 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 KANJISJIS_0S character set includes all the characters in the JIS X 0201 and JIS X 0208 standards, plus extensions, including single-byte Hankaku Katakana characters and multibyte Kanji characters.

KANJISJIS_0S is not 100% compatible with the latest Windows code page 932 as the mapping to Unicode is different for several Japanese characters including the Yen symbol. Therefore, the best practice is to use KANJI932_1S0 and UTF8/UTF16 session character sets with the UNICODE server character set.

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 KANJISJIS_0S 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 KANJISJIS_0S object names.

The following table provides a complete list of multibyte character codes that are not valid for object names under the KANJISJIS_0S 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 information on the rules and restrictions for naming Teradata Database objects, see the topics beginning with “About Object Names” on page 17.

Also see SQL Fundamentals, which covers topics such as:

Translation conventions for storing object names in the data dictionary

Rules for object name comparison

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.