15.10 - KANJISJIS_0S - Teradata Database

Teradata Database International Character Set Support

Teradata Database
User Guide

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




0x40 - 0x49

0x4C - 0x50

0x52 - 0x5A

0x5C - 0x8F

0x91 - 0x93

0x95 - 0xFC


0x9F - 0xFC


0x40 - 0xFC


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.