For example, you have a Japanese language table named .
If you submit a HELP DATABASE statement for the database that contains the table, the HELP output includes object names/titles, followed by the 3 associated name/title fields, the content of which differs based on the session character set.
For a UTF8 or UTF16 session, where the table name translates into the session character set, the table portion of the HELP output appears similar to the following, with some output lines omitted for clarity:
Table Name:
Table Dictionary Name:
Table SQL Name:
Table UEscape:?
Title: BigTable1
Dictionary Title: BigTable1
SQL Title: 'BigTable1'
Title UEscape: ?
where the ? value for UEscape represents NULL, which is used because all SQL Name and SQL Title characters are translatable into the session character set and no delimiter is required.
For 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: \
Table Title: BigTable1
Dictionary Title: BigTable1
SQL Title: 'BigTable1'
Title 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" | The SQL Name begins with U& to indicate that it is a UNICODE delimited identifier, that is, it 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, in this case, \. The string is enclosed in quotation marks so that the delimiter characters it contains can be used in an SQL request. The system does not return the UEscape clause, which normally 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. See Using an SQL Name or SQL Title Value in an SQL Request.
|
| Table UEscape: \ | Indicates the delimiter character used to separate the UNICODE identifiers in the SQL Name. |