There are two categories of character sets in a Teradata Database environment.
Category |
Description |
Client (session) character set |
|
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.”