Object Names - Advanced SQL Engine - Teradata Database

International Character Set Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
xnf1627504141606.ditamap
dita:ditavalPath
xnf1627504141606.ditaval
dita:id
B035-1125
lifecycle
previous
Product Category
Teradata Vantage™

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:
  • IBM Extended non-Kanji
  • IBM Basic Kanji
  • IBM Extended Kanji
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