17.10 - Object Names - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine International Character Set Support

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
User Guide
Publication ID
English (United States)

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