17.10 - Default Language Support Mode - 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)
Each Teradata Database 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 … Teradata Database 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, the Teradata Database 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