Oracle 参数 NLS_LANGUAGE 官方解释，作用，如何配置最优化建议

本站中文解释

NLS_LANGUAGE 参数指定客户端与服务器之间使用的语言。

设置 NLS_LANGUAGE:
1. 打开 Oracle 安装目录中默认路径下的“network/admin”文件夹；
2. 在 tnsnames.ora 文件中，找到你需要设置 NLS_LANGUAGE 的数据库条目；
3. 在该条目下，加入 NLS_LANGUAGE 的值；
4. 保存修改；
5. 重新启动受影响的服务器进程，使新的 NLS_LANGUAGE 设置生效。

NLS_LANGUAGE 的值被定义为 ISO639-1 标准规范的国家/地区名称，如中文对应的值为SIMPLIFIED CHINESE。

官方英文解释

NLS_LANGUAGE specifies the default language of the database.

Property	Description
Parameter type	String
Syntax	`NLS_LANGUAGE =` `language`
Default value	Operating system-dependent, derived from the `NLS_LANG` environment variable
Modifiable	`ALTER SESSION`
Modifiable in a PDB	Yes
Range of values	Any valid language name
Basic	Yes

This language specified by NLS_LANGUAGE is used for messages, day and month names, symbols for AD, BC, a.m., and p.m., and the default sorting mechanism. This parameter also determines the default values of the parameters NLS_DATE_LANGUAGE and NLS_SORT.

Note:

The value of this initialization parameter NLS_LANGUAGE is used to initialize the session value of this parameter, which is the actual value referenced by the SQL query processing. This initial value is overridden by a client-side value if the client uses the Oracle JDBC driver or if the client is OCI-based and the NLS_LANG client setting (environment variable) is defined. The initialization parameter value is, therefore, usually ignored.

Examples

See these examples of using the NLS_LANGUAGE parameter:

For an example of setting NLS_LANGUAGE to Italian, see Oracle Database
Globalization Support Guide.
For an example of overriding default values for NLS_LANGUAGE and NLS_TERRITORY during a session, see Oracle Database
Globalization Support Guide.