The term KanjiEBCDIC refers collectively to these character sets:
These character sets emulate the IBM style, where the multibyte character sequence in a character string is bracketed by Shift-Out and Shift-In characters.
Character Set Name |
CCSID1 |
GCSGID2 |
CPGID3 |
Description |
KANJIEBCDIC5026_0I |
05026 |
01172 |
00290 |
Single-byte |
00370 |
00300 |
Multibyte; 1880 user-defined characters |
||
KANJIEBCDIC5035_0I |
05035 |
01172 |
01027 |
Single-byte |
00370 |
00300 |
Multibyte; 1880 user-defined characters |
||
KATAKANAEBCDIC |
13218 |
00332 |
00290 |
Single-byte; no 'a'-'z' |
00370 |
00300 |
Multibyte; 1880 user-defined characters |
Hexadecimal Value |
Character |
Description |
0x10 |
¢ |
Cent sign |
0x11 |
£ |
Pound Sterling currency symbol |
0x12 |
¬ |
IBM logical NOT sign |
0x13 |
\ |
Backslash |
Because other translations map the values to control characters, they cannot be shared with other client character sets.
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” on page 17.
For additional rules and restrictions that apply to naming Teradata Database objects, see SQL Fundamentals.
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 |
the following shaded areas in “EBCDIC Kanji Character Set” on page 159: |
|
KANJIEBCDIC5026_0I |
“EBCDIC Japanese Extended Katakana Character Set” on page 156. |
|
KANJIEBCDIC5035_0I |
“EBCDIC Japanese Extended English Character Set” on page 158. |
Double-byte characters in the User and Marker areas in “EBCDIC Kanji Character Set” on page 159 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 |