Usage Notes - Interactive Teradata Query Facility

Interactive Teradata Query Reference

Interactive Teradata Query Facility
Release Number
English (United States)
Last Update
Product Category
Teradata Tools and Utilities

Usage Notes

The .[SET] SESSION CHARSET command specifies the name of the character set to be used for the current session. The character sets are user-definable and defined in the CharTranslations View.

You can choose the character set either by name or by numeric code. It is recommended to enter the character set by name. If selecting by name, the name must exist in the CharSetName column in the CharTranslations View. If selecting by code, the code must exist in the CharSetId column in the CharTranslations View and be in the range of 65 to 126.

The HELP SESSION command displays the current collation and character set of your session. See the example below.

The .[SET] SESSION CHARSET command cannot be used in a Teradata SQL macro.