Client Character Information in System Tables - Teradata Database

International Character Set Support

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-09-25
dita:id
B035-1125
lifecycle
previous
Product Category
Teradata® Database

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 Chapter 3: “Using Standard Teradata Client Character Sets.”