15.10 - About Character Sets - Teradata Database

Teradata Database International Character Set Support

prodname
Teradata Database
vrm_release
15.00
15.10
category
Configuration
User Guide
featnum
B035-1125-015K

There are two categories of character sets in a Teradata Database environment.

 

Category

Description

Client (session) character set

  • Used by a client to log on and make requests to the database.
  • Used by the database for data returned to the client.
  • Server or internal (database) character set

    Used by the database to store user data.

    The system processes the character data in client requests to the database as follows:

    1 A user submits a request in the character set specified as the client default.

    2 The database converts the client characters it receives to the default server character set (external-to-internal, or E2I conversion) for processing and data storage.

    3 The database converts data from the internal database character set back to the client character set (internal-to-external, or I2E conversion) when returning answers sets to the requesting client.

    For information on character conversion options, see Chapter 8: “Character Conversion.”