The Teradata Database can support many user-defined character sets (see 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 Teradata Database administrator.