IF you want to… |
THEN… |
display the client character set currently in effect for your session |
use the HELP SESSION statement. |
review the contents of the system tables associated with language support |
query the DBC.HostsInfoV, DBC.CharSetsV, or DBC.CharTranslationsV views. |
The presence of a character set in DBC.CharSetsV or DBC.CharTranslationsV does not mean it is active. The InstallFlag column in DBC.CharSetsV or DBC.CharTranslationsV is a good indication, but can be misleading if the table has been changed without performing a restart of the Teradata Database.
ASCII, EBCDIC, UTF16, and UTF8 character sets, which are predefined and permanently loaded into the system, are always available. The character sets are not listed in DBC.CharTranslationsV.