Client Character Information in System Tables | Teradata Vantage - 17.10 - Client Character Information in System Tables - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Advanced SQL Engine International Character Set Support

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
User Guide
Publication ID
B035-1125-171K
Language
English (United States)

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