16.10 - Default Language Support Mode - Teradata Database

Teradata Database International Character Set Support

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Configuration
User Guide
featnum
B035-1125-161K

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