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. 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 objects, see SQL Fundamentals, B035-1141.