16.10 - Client Character Information in System Tables - Teradata Database

Teradata Database International Character Set Support

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Configuration
User Guide
featnum
B035-1125-161K

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