Skip Headers
Oracle® Database Client Installation Guide
10g Release 2 (10.2) for AIX 5L Based Systems (64-Bit)

Part Number B19077-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

B Configuring Oracle Database Globalization Support

This appendix describes these Globalization Support topics:

B.1 About NLS_LANG Environment Variable

Oracle provides Globalization Support that enables users to interact with a database in their preferred locale and character set settings. Setting the NLS_LANG environment variable specifies locale behavior for Oracle software. It sets the language and territory used by the client application and the database server. It also sets the character set for entering and displaying data by a client program, such as SQL*Plus.

The NLS_LANG environment variable uses the following format:

NLS_LANG=language_territory.characterset

where:

Parameter Description
language Specifies the language used for displaying Oracle messages, sorting, day names, and month names.
territory Specifies the conventions for default date, monetary and numeric formats.
characterset Specifies the encoding used by the client application (normally the Oracle character set that corresponds to the character set of the user terminal or the operating system)

The NLS_LANG environment variable is set as a local environment variable for the shell on all UNIX-based platforms. For example, if the operating system locale setting is en_US.UTF-8, then the corresponding NLS_LANG environment variable should be set to AMERICAN_AMERICA.AL32UTF8.

See Also:

Oracle Database Globalization Support Guide for information about the NLS_LANG parameter and Globalization Support initialization parameters

The following table lists some of the valid values for the NLS_LANG environment variable.

Note:

Refer to the operating system specific documentation on how to determine the operating system locale environment setting.
Operating system locale NLS_LANG values
French (France) FRENCH_FRANCE.WE8ISO8859P15, FRENCH_FRANCE.WE8ISO8859P1, FRENCH_FRANCE.WE8MSWIN1252, FRENCH_FRANCE.AL32UTF8
Japanese (Japan) JAPANESE_JAPAN.JA16EUC, JAPANESE_JAPAN.JA16SJIS, JAPANESE_JAPAN.AL32UTF8

B.2 Running Oracle Universal Installer in Different Languages

Oracle Universal Installer runs by default in the selected language of your operating system. You can also run Oracle Universal Installer in the following languages:

To run Oracle Universal Installer in a different language, you can use any of the following methods:

See Also:

Oracle Universal Installer and OPatch User's Guide for information about running Oracle Universal Installer in different languages