The following user views provide access to the Vantage 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 Vantage 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 database.
These character sets are currently active and available to specify at the session level only if a restart of the 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:
- Activate a client character set to make it available at the session level.
- Define your own site-defined or extended site-defined client character sets.
- Change the default client character set for a host.
For details on activating client character sets and changing the default client character set for a host, see Using Standard Teradata Client Character Sets