17.20 - Object Names - Analytics Database - Teradata Vantage

Teradata Vantage™ - Analytics Database International Character Set Support - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-01-27
dita:mapPath
aju1628095815656.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
hqj1472245413611

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