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. 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.
Also see SQL Fundamentals, which covers topics such as:
- Translation conventions for storing object names in the data dictionary
- Rules for object name comparison