About Character Sets - 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

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.”