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.
For information on the rules and restrictions for naming Teradata Database objects, see the topics beginning with About Object Names.
For additional rules and restrictions that apply to naming Teradata Database objects, see Teradata Vantage™ - SQL Fundamentals, B035-1141.
The following table shows where to find information on characters allowed in object names.
IF the client character set is … | THEN object names can contain single-byte Latin and Katakana characters shown in … | AND double-byte characters shown in … |
---|---|---|
KATAKANAEBCDIC | EBCDIC KATAKANA Character Set. | the following shaded areas in EBCDIC Kanji Character Set:
|
KANJIEBCDIC5026_0I | EBCDIC Japanese Extended Katakana Character Set. | |
KANJIEBCDIC5035_0I | EBCDIC Japanese Extended English Character Set. |
Double-byte characters in the User and Marker areas in EBCDIC Kanji Character Set are not valid for object names. Additionally, double-byte characters in the following table are not in JIS X 0208 and are not valid for object names under KANJIEBCDIC5026_0I, KANJIEBCDIC5035_0I, and KATAKANAEBCIDC.
First Byte | Second Byte | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0x40 | 40 | |||||||||||||
0x41 | 41 - FE | |||||||||||||
0x42 | 41 - 6C | 6E - 7A | 7C - 80 | AA - C0 | EA - EF | FA - FE | ||||||||
0x43 | 41 - 45 | 4A - 4F | 5B - 7A | 7C - 7F | A1 | B0 - B9 | DC - DD | |||||||
E0 - F2 | ||||||||||||||
0x44 | 42 - 45 | 4A - 4E | 50 | 5A - 7F | DC - DD | E0 - F3 | ||||||||
0x51 | BF | DA | F7 | |||||||||||
0x52 | 4B | 7B | 94 | 9E | EB | |||||||||
0x53 | 86 | 94 | 97 | C7 | ||||||||||
0x56 | 44 | 5D | 62 | 65 - 66 | 6A | 6E | 70 - 71 | 74 | 7B | 86 | 8A | 91 | ||
94 | 98 | A2 - A4 | A8 | B2 | B5 | C9 | CE | DC | E8 | EF | F7 | |||
0x57 | 4F | 50 | 56 | 58 | 61 | 63 | 6B | 7C | 80 | 87 | 8B | 8E | A9 | AE |
BD | C0 | DE | ||||||||||||
0x58 | 60 | 63 | 6C | 70 | 73 | 77 | 82 | 8A | 8C | A1 | AD | B0 | B1 - B2 | |
BE | C0 | EC | FC | FE | ||||||||||
0x59 | 42 | 44 | 51 | 67 - 68 | 70 | 78 | 7F | 80 | 84 | 87 | 93 | 95 | 97 | |
C7 | CB | D8 | E8 | F1 | ||||||||||
0x5A | 44 | 51 | 57 | 5F | 65 | 67 - 68 | 76 | 79 | 7E | 94 | B5 | DA | FB | |
0x5B | 50 | 53 - 54 | 7E | 97 - 99 | 9D | A0 - A1 | A4 | A7 - A8 | AB | F9 | ||||
AE - AF | B4 | B6 | B8 | BB | C7 - C9 | D8 | E3 | EC | F0 | F3 | ||||
0x5C | 5F | 66 | 6E | 78 - 79 | 90 | 9A - 9B | A6 | A9 | AF | B9 | BC | EA | ||
F6 | F9 | FD - FE | ||||||||||||
0x5D | 4E | 58 | 60 | 62 | 6B | 72 | 74 | 7A | 7F | 80 | 8A | 8E | 93 | 95 |
A6 | C1 | CA | D5 | D7 - D8 | E3 | EA | ED | F5 - F6 | FB - FD | |||||
0x5E | 49 | 4B | 5A | 73 | 75 | 86 | 8A | 94 | 99 | 9E - 9F | A1 - A2 | |||
A7 - A8 | AA - AB | AD - AE | BC - BD | C0 | D1 | E7 | ||||||||
0x5F | 69 | 70 - 73 | 7A | 8E | AA | AE | B2 - B3 | B6 | D1 - D2 | D5 | D9 | |||
DC - DD | DF | |||||||||||||
0x60 | 4F | 58 - 5A | 82 | AD | C4 | C6 | D4 | DA | E1 | FD | ||||
0x61 | 57 | 6E | 77 | F8 | ||||||||||
0x62 | 48 | 5B | 67 | 74 | 7E | 8A | 9E | A1 | A8 | B9 | BB | CE | E2 | |
0x63 | 5E | 90 | C5 | CB | D4 | DF | E1 | ED - EF | ||||||
0x64 | 45 | 50 | 7C - 7D | 85 | 8D - 8E | C9 | F1 | |||||||
0x65 | 49 | 53 | 64 | 66 - 67 | 6B | 83 | 85 - 86 | 8A | 8C - 8D | 8F | 90 | |||
93 | 95 | 9B | 9E - 9F | A1 | A3 | A5 - A6 | A8 | AB - AD | B4 - B9 | |||||
BC - BD | C1 | C3 | C5 - C6 | C8 - C9 | CC | CE | D0 | D5 | D8 | DD | ||||
E4 | E8 | F0 | F4 | F6 | ||||||||||
0x66 | 4A | 74 | 78 - 79 | 7F | 97 | 99 | 9E | A2 - A5 | CB - CC | DD | DF | |||
E5 - E6 | F9 | |||||||||||||
0x67 | 59 | 6B - 6C | 8F | 91 | 93 | 9B | 9F | B1 | E2 | E4 | F4 | FE | ||
0x68 | 56 |