Client Character Sets - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
English (United States)
Last Update
Product Category

Client Character Sets

Each client uses a particular character set during a session to transmit user data. The client character set maps each character in the client to an equivalent character in the server set.

Teradata Database translates data strings received from a client into the server, or internal, character set for storage and processing, and translates it back to the client character set when exporting response data to the client. This translation allows clients using different character sets to access and modify the same stored data.

Teradata Database offers many predefined client character sets (along with the codes for the appropriate collation sequences). However, you can also define and install your own character set translations and collations on the server and flag those currently desired as available for use. You can assign an active character set as the default for a client and also activate up to a maximum of 16 client character sets.

Note: The ASCII, EBCDIC, UTF-8, and UTF-16 character sets are permanently installed and always available.

Viewing the Status of Client Character Sets

Use the views described below to determine the current status of installed character sets.


View Name



Displays the names of installed character sets.

Each name identifies the set of translation tables needed to define the external-internal character mapping for one language. They can be predefined, or created by you.

Note: Because they are permanently loaded and available, the ASCII, EBCDIC, UTF-8, and UTF-16 character sets are not reported.


Displays the names of the character sets you flagged in the DBC.Translations table as the ones to activate during a tpareset.

These are currently active and available to users at the session level only if a tpareset was performed after you set the flags.

Note: A name in this view and CharTranslationsV does not prove that it is active. The InstallFlag column in CharTranslationsV is an indication, but can be misleading if the table was changed without a tpareset.


Displays the names of the character sets you assigned as the client defaults, by host.

Client character sets permanently enabled by Teradata Database include:

  • UTF-8
  • UTF-16
  • For more information on mapping and collation codes, see International Character Set Support. For IBM mainframe clients, see “TDP Functionality” on page 428 and Teradata Director Program Reference.

    For a complete description of the views described in the previous table, see Data Dictionary.