Default Language Support Mode - 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™
Each Vantage system is configured for a language support mode as part of sysinit:

The language support mode determines the default server character set, which in turn determines which character set is used to store data.

IF you enable this language support mode … Vantage stores object names using … and the user default server character set is…
Standard UNICODE LATIN
Japanese UNICODE UNICODE

The default server character set also determines which client character sets are supported. Client Character Set Compatibility with Server Character Sets.

You can override the global default server character set associated with the language mode by specifying a default server character set for specific users or table columns.

For details about server character set options, see Server Character Sets.

Enabling the Language Support Mode

During the sysinit process, at the following prompt appears:

Enable Japanese language support?

To optimize the database for Japanese language support, answer YES. Otherwise, answer NO.

If you answer NO, Vantage uses standard language support.

Determining the Current Language Support Mode

To determine the current language support mode on your system, enter this command:

SELECT * FROM dbc.dbcinfoV WHERE infokey = 'LANGUAGE SUPPORT MODE';

For Japanese systems, the system returns:

*** Query completed. One row found. One column returned. 
   *** Total elapsed time was 1 second.
InfoData
--------------------------------------
Japanese

For Non-Japanese systems, the system returns:

*** Query completed. One row found. One column returned. 
   *** Total elapsed time was 1 second.
InfoData
--------------------------------------
Standard