External and Internal Character Sets - Advanced SQL Engine - Teradata Database

Database Introduction

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
qia1556235689628.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1091
lifecycle
previous
Product Category
Teradata Vantageā„¢

Client systems communicate with Teradata Database using their own external format for numbers and character strings.

Teradata Database converts numbers and strings to its own internal format when importing the data, and converts numbers and strings back to the appropriate form for the client when exporting the data.

This allows data to be exchanged between mutually incompatible client data formats. Take for example, mainframe-attached clients using EBCDIC-based character sets and workstation-attached clients using ASCII-based character sets. Both clients can access and modify the same data in Teradata Database.