Working with Unicode Delimited Identifiers | VantageCloud Lake - Working with Unicode Delimited Identifiers - Teradata VantageCloud Lake

The system allows the use of UNICODE delimited identifiers to enable specification of object names and literals having characters that are not compatible with the session character set.

System Use of Unicode Delimited Identifiers

For example, the table name:

In an ASCII session, where the table name does not translate into the session character set, the table portion of the HELP output appears similar to the following:

Table Name: ^Z^Z^Z^Z
Table Dictionary Name: ^Z^Z^Z^Z
Table SQL Name: U&"\FF83\FF70\FF8C\FF9E\FF99"
Table UEscape: \ 

where:

Output	Description
Table Dictionary Name: ^Z^Z ^Z^Z	Each ^Z represents an ASCII replacement character, 0x1A, used to replace the 4 untranslatable characters, . The system uses ^ to represent unprintable control characters.
Table SQL Name: U&"\FF83\FF70\FF8C\FF9E\FF99"	U& indicates a UNICODE delimited identifier. That is, an identifier that contains untranslatable characters. The sequence \FF83\FF70\FF8C\FF9E\FF99 is the set of UNICODE identifiers for the 4 untranslatable characters, preceded by the default delimiter character, \. The quotation marks allow the delimiter characters in the string to be used in an SQL request. The system does not return the UEscape clause, which typically closes a UNICODE delimited identifier. If you want to use a UNICODE delimited identifier in an SQL request, you need to add the UEscape clause.
Table UEscape: \	Indicates the delimiter character used to separate the UNICODE identifiers in the SQL Name.

Using an SQL Name or SQL Title Value in an SQL Request

You can use the SQL Name or SQL Title of an object returned as the result of a HELP request in an SQL request.

For example, you can use HELP DATABASE to look in the mydb database for the name of a table you want to drop:

HELP DATABASE mydb;

Output:

… Table SQL Name U&"table_\4E00_name"
   Table UEscape		 \ 

The SQL Name returned by the HELP DATABASE statement is a UNICODE delimited identifier, which includes an untranslatable character that the system expresses as \4E00.

If you want to use a UNICODE delimited identifier from the SQL Name as part of an SQL request, you must:

1. Add the closing UEscape clause to the table name taken from the SQL Name field.
2. Specify the delimiter character ( \ )

For example:

Drop Table U&"table_\4E00_name" UEscape '\';

If the SQL Name is not a UNICODE delimited identifier, you can use the name in an SQL request as the name appears in the HELP output, without specifying the UEscape phrase and delimiter.

Determining the Delimiter Character

The UEscape field that follows each SQL Name field must be used to identify the delimiter used.