A script-enabled browser is required for this page to function properly.

NLS_LANG environment variable

This environment variable specifies the language, territory, and character set used, including:

Syntax

NLS_LANG=language_territory.charset

Parameters

Description

language

Specifies the language and its conventions for displaying messages and day and month names.

territory

Specifies the territory and its conventions for calculating week and day numbers.

charset

Specifies the character set used for the UPPER, LOWER, and INITCAP functions, and the type of sort used by an ORDER BY query. This argument also controls the character set used for displaying messages.

 

Valid Values

 

See the chapter "NLS and Bidirectional Support" in the OracleAS Reports Services Publishing Reports to the Web manual, available on the Oracle Technology Network Oracle Reports Documentation page (http://www.oracle.com/technology/documentation/reports.html).

For additional information, also see the Oracle Application Server Globalization Support Guide on the Oracle Technology Network (http://www.oracle.com/technology/index.html).

Default

AMERICAN_AMERICA.WE8ISO8859P1

Usage notes

Examples

Suppose you want your application to run in French. The application will be used in France and data will be displayed using the WE8ISO8895P1 character set. You would set NLS_LANG as follows:

NLS_LANG=French_France.WE8ISO8895P1

Now, suppose you still want your application to run in French, but this time it will be used in Switzerland. You would set NLS_LANG as follows:

NLS_LANG=French_Switzerland.WE8ISO8895P1

More examples:

NLS_LANG=Norwegian_Norway.NDK7DEC
NLS_LANG=Norwegian_Norway.WE8ISO8895P1
NLS_LANG=Japanese_Japan.JA16SJIS
NLS_LANG=Arabic_Egypt.AR8MSWIN1256
NLS_LANG=American_America.AR8MSWIN1256
NLS_LANG=American_America.WE8ISO8859P1

See also

Environment variables

The chapter "NLS and Bidirectional Support" in the OracleAS Reports Services Publishing Reports to the Web manual, available on the Oracle Technology Network Oracle Reports Documentation page (http://www.oracle.com/technology/documentation/reports.html).