Hexadecimal Representation of Object Names | VantageCloud Lake - Hexadecimal Representation of Object Names - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

All object names are stored in the Data Dictionary in UNICODE. However, in an international environment, client users may find that their client (session) character set cannot express an object name created on another client. In these cases, you can use a hexadecimal representation of the unavailable UNICODE characters in the object name to more easily access the object.

Using Delimiters with Hexadecimal Identifiers

When you reference a database object using a hexadecimal representation of the object name, you must express the hexadecimal representation as a name literal or enclose the name in UNICODE delimiters.

The best practice is to use UNICODE delimited identifiers because the hexadecimal value remains the same across all supported character sets, whereas using hexadecimal name literals allows the name representation to vary depending on the character set.

Example: Using UNICODE Delimited Identifiers

Consider a table name of where the translation to the UNICODE server character set is equivalent to the following Unicode delimited identifier:

U&"#FF83#FF70#FF8C#FF9E#FF99" UESCAPE '#'

From a client where the client character set is KANJIEUC_0U, you can access the table using the following hexadecimal name literal:

'80C380B080CC80DE80D9'XN

From a client where the client character set is KANJISJIS_0S, you can access the table using the following hexadecimal name literal:

'C3B0CCDED9'XN

Example: Using Hexadecimal Name Literals

Here is an example of a Unicode delimited identifier that represents the name TAB1 on a system enabled for Japanese language support:

SELECT EmployeeID FROM U&"#FF34#FF21#FF22#FF11" UESCAPE '#';