17.10 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

Teradata Vantage can support many user-defined character sets (see view CharTranslationsV). You can install a maximum of 12 character sets at any given time. The CharSets view contains the names of character sets that are currently installed and can be specified at the session level. If the view does not exist or no rows are found, then no user-defined character sets are available.


Each name shown in CharSets can be used as the identifier in the BTEQ [.]SET SESSION CHARSET <'name'> command or the CLIv2 call CHARSET <name>. However, the specified character set should be compatible with the internal code of the logon client system.

If a CharSetName is ambiguous as to its compatibility with the logon client system of the viewer session, consult the database administrator.