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:
- 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