Unprintable Characters in Object Names and Literals | SHOW Statement | Vantage - Unprintable Characters in Object Names and Literals Returned by SHOW - Advanced SQL Engine - Teradata Database

If an object name or literal returned by a SHOW request includes a character not in the repertoire of the session character set, or is otherwise unprintable, the name or literal is shown as a UNICODE delimited identifier or literal.

Each non-representable character is escaped to its hexadecimal equivalent.

For example:

create table u&"#4E00" uescape'#' (i int);
show table u&"#4E00" uescape'#';

Object names that are translatable to the session character set, but are not lexically distinguishable as names are enclosed in double quotation marks.

Using SHOW Output with Escape Characters in an SQL Statement

You can use SHOW output containing escape characters in another SQL statement. For example, using the SHOW output from the previous topic:

CREATE SET TABLE U&"\4E00" UESCAPE '\' ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL,
     CHECKSUM = DEFAULT,
     DEFAULT MERGEBLOCKRATIO
     (
      i INTEGER)
PRIMARY INDEX ( i );