16.20 - Client Character Information in System Tables - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ NewSQL Engine International Character Set Support

Teradata Database
Teradata Vantage NewSQL Engine
March 2019
User Guide

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