Client Character Set Compatibility with Server Character Sets - Analytics Database - Teradata Vantage

International Character Set Support

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-09-27
dita:mapPath
aju1628095815656.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
hqj1472245413611
lifecycle
latest
Product Category
Teradata Vantageā„¢

To be usable, a client character set must compatible with the applicable default server character set.

The default server character set is determined in the following hierarchical order. If a default is not defined, the system defers to the next lower item on the list:

  1. Table column default character set
  2. User default character set
  3. System (global) default character set.
    The current system default is defined in the DBSControl DefaultCharacterSet field.

For more information about defining the default server character set, see Specifying the Default Server Character Set.

The following table lists client-server character set compatibilities:

If the default server character set is... The client character set can be...
LATIN
  • ASCII
  • EBCDIC
  • EBCDIC037_0E
  • EBCDIC277_0E
  • EBCDIC273_0E
  • LATIN1_0A
  • LATIN9_0A
  • LATIN1252_0A
  • A simple site-defined ASCII-based character set
Do not use client character sets other than those listed to insert data into a LATIN column, even if the character set appears to be represented in LATIN (for example, Turkish). The system may incorrectly translate such characters when converting them to UNICODE.
UNICODE Any valid single- or multibyte client character set.
KANJISJIS KANJISJIS supports mixed single and multibyte characters and its form-of-use is identical with that of its client character set analog
GRAPHIC Multibyte characters from the defined Graphic repertoire of the following character sets:
  • KanjiEBCDIC
  • KanjiSJIS_0S
  • KanjiEUC_0U