System Processing | International Character Set Support | Teradata Vantage - 17.10 - System Processing of Character Data - 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 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 Character Conversion.