17.20 - Object Names - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine International Character Set Support

Advanced SQL Engine
Teradata Database
Release Number
June 2022
Last Update
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 KANJISJIS_0S 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 KANJISJIS_0S object names.

The following table provides a complete list of multibyte character codes that are not valid for object names under the KANJISJIS_0S 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 information on the rules and restrictions for naming objects, see the topics beginning with Object Names.

Also see Teradata Vantage™ - SQL Fundamentals, B035-1141, which covers topics such as:
  • Translation conventions for storing object names in the data dictionary
  • Rules for object name comparison