


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). If the territory is not specified, then the value is derived from the language value. Each supported territory has a unique name for example, AMERICA, FRANCE, or CANADA. Specifies conventions such as the default date, monetary, and numeric formats. If the language is not specified, then the value defaults to AMERICAN The language argument specifies default values for the territory and character set arguments. Each supported language has a unique name for example, AMERICAN, FRENCH, or GERMAN. Specifies conventions such as the language used for Oracle messages, sorting, day names, and month names. Specify it in the following format, including the punctuation:Įach component of the NLS_LANG parameter controls the operation of a subset of globalization support features: The NLS_LANG parameter has three components: language, territory, and character set. NLS_LANG is set in the registry on Windows platforms. NLS_LANG is set as a local environment variable on UNIX platforms. 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. It sets the language and territory used by the client application and the database server. Setting the NLS_LANG environment parameter is the simplest way to specify locale behavior for Oracle software. 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. Traditionally, the data associated with a locale provides support for formatting and parsing of dates, times, numbers, and currencies, etc. A locale is a set of information addressing linguistic and cultural requirements that corresponds to a given language and country.
