- Standard (For details, see Standard Language Support Mode.)
- Japanese (For details, see Japanese Language Support Mode.)
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