关于字符和nls参数

NLS_LANG

(Read-only) The NLS_LANG option specifies thecurrent language, territory, and database character set, which are determinedby session-wide globalization parameters.

Data Type

TEXT

Syntax

NLS_LANG 

Parameters

See Oracle Database Globalization Support Guide formore information about NLS database parameters.

Examples

Example 5-75 Checking the Current Value of NLS_LANG

A SHOW NLS_LANG statement might produce the following.

AMERICAN_AMERICA.WE8ISO8859P1

 

NationalLanguage Support (NLS) is a technology enabling Oracle applications to interactwith users in their native language, using their conventions for displayingdata.

12.4.1 NLS Parameters insidENV

NLS_LANG must be specified to define the character set usedby the gateway.  The NLS_LANG parameter must be changed in the data setspecified by the ORA$ENV DD statement.

The syntax for the NLS_LANG parameter is:

NLS_LANG='language[_territory.character_set]'

where:

Parameter

Description

language

is any language listed in Table 0–2, " Supported Languages and Territories".

territory

is optional and defaults to AMERICA. Refer to Table 0–2, " Supported Languages and Territories", for a list of supported territories.

character_set

defaults to WE8EBCDIC1047. It must correspond with a character set used by the DB2 system.

Since DB2 does not support the z/OS Oracle server default character set of WE8EBCDIC1047, you must always specify a character set that is supported by DB2, or accept the default.

 

NLS_NCHAR must be specified for DBCS users.  Thesyntax is:

NLS_NCHAR='character_set'

For example:

NLS_NCHAR='KO16DBCS'

http://docs.oracle.com/html/B13531_01/ap_b.htm

 

nls 简写 oracle  谷歌

本地字符集 oracle

本地字符集 oracle nls

https://community.oracle.com/thread/2432536?start=0&tstart=0

 

Setting Up a Globalization Support Environment

Setting NLS Parameters

http://docs.oracle.com/cd/E11882_01/server.112/e10729/ch3globenv.htm#NLSPG003

 

看博主：http://blog.csdn.net/haibusuanyun/article/category/1617489