The following user views provide access to the Teradata Database system tables containing client character set information.
View Name |
Contents of the Underlying System Table |
DBC.CharTranslationsV |
International client character set definitions, including the character set names and translation codes that the Teradata Database uses to translate character data between client and server forms. |
DBC.CharSetsV |
Names of character sets that are flagged as the character sets to activate during a restart of the Teradata Database. These character sets are currently active and available to specify at the session level only if a restart of the Teradata Database was performed after the flags were set. |
DBC.HostsInfoV |
The default client character set name for each host, if any. |
You may need to access these tables to:
For details on activating client character sets and changing the default client character set for a host, see Chapter 3: “Using Standard Teradata Client Character Sets.”