NLS_LANG介绍及默认值

NLS_LANG Parameter Fundamentals

 

A locale is a set of information addressing linguistic and cultural requirements that corresponds to a given language and country. Traditionally, the data associated with a locale provides support for formatting and parsing of dates, times, numbers, and currencies, etc. Providing current and correct locale data has historically been the responsibility of each platform. owner or vendor, leading to inconsistencies and errors in locale data.

 

Setting the NLS_LANG environment parameter is the simplest way to specify locale behavior. for Oracle software. It sets the language and territory used by the client application and the database server. It also indicates the client's character set, which corresponds to the character set for data to be entered or displayed by a client program.

 

NLS_LANG is set as a local environment variable on UNIX platforms. NLS_LANG is set in the registry on Windows platforms.

 

The NLS_LANG parameter has three components: language, territory, and character set. Specify it in the following format, including the punctuation:

 

 

NLS_LANG = language_territory.charset

 

Each component of the NLS_LANG parameter controls the operation of a subset of globalization support features:

 

Language

 

Specifies conventions such as the language used for Oracle messages, sorting, day names, and month names. Each supported language has a unique name; for example, AMERICAN , FRENCH , or GERMAN . The language argument specifies default values for the territory and character set arguments. If the language is not specified, then the value defaults to AMERICAN .

 

Territory

 

Specifies conventions such as the default date, monetary, and numeric formats. Each supported territory has a unique name; for example, AMERICA , FRANCE , or CANADA . If the territory is not specified, then the value is derived from the language value.

 

Charset

 

 

Specifies the character set used by the client application (normally the Oracle character set that corresponds to the user's terminal character set or the OS character set). Each supported character set has a unique acronym, for example, US7ASCII , WE8ISO8859P1 , WE8DEC , WE8MSWIN1252 , or JA16EUC . Each language has a default character set associated with it.

Default vale

 

If you don't set the NLS_LANG on the client it uses the NLS_LANG of the server. This is also NOT true! For example, if the Oracle Installer does not populate NLS_LANG , and it is not otherwise set then its value by default is A MERICAN_AMERICA.US7ASCII . The language is AMERICAN , the territory is AMERICA , and the character set is US7ASCII .

 

If NLS_LANG is specified with only the part then AMERICAN is used as default .

 

If NLS_LANG is specified with only the part then the defaults to a setting based on .

 

If NLS_LANG is specified without the _ part then the _ part defaults to AMERICAN_AMERICA.

 

 

If the NLS_LANG is not set at all, then it defaults to

_.US7ASCII and the values for the

_ part used are the ones found in

NLS_INSTANCE_PARAMETERS. Parameters like NLS_SORT defined as "standalone" on the client side are ignored.

 

 【参考地址】http://www.oracle.com/technetwork/database/globalization/nls-lang-099431.html

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15747463/viewspace-769024/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15747463/viewspace-769024/