1,oracle数据库的nls_lang
SQL> col PARAMETER for a30
SQL> r
1* SELECT * FROM v$nls_parameters
PARAMETER VALUE
------------------------------ ------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_CHARACTERSET ZHS16GBK
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
PARAMETER VALUE
------------------------------ ------------------------------
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
19 rows selected.
2,oracle数据库服务器的环境变量nls_lang
[oracle@node1 ~]$ more .bash_profile
# .bash_profile
PATH=$PATH:$HOME/bin
export PATH
alias sqlplus='rlwrap sqlplus'
alias rman='rlwrap rman'
export EDITOR=vi
export ORACLE_SID=test
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin
umask 022
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
[oracle@node1 ~]$ env | grep NLS_LANG
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
3,客户端所在os的环境变量的nls_lang
我的电脑--属性--环境变量--新建环境变量 NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
这三个参数必须完全一致,才能有效使用中文字符
SQL> col PARAMETER for a30
SQL> r
1* SELECT * FROM v$nls_parameters
PARAMETER VALUE
------------------------------ ------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_CHARACTERSET ZHS16GBK
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
PARAMETER VALUE
------------------------------ ------------------------------
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
19 rows selected.
[oracle@node1 ~]$ more .bash_profile
# .bash_profile
PATH=$PATH:$HOME/bin
export PATH
alias sqlplus='rlwrap sqlplus'
alias rman='rlwrap rman'
export EDITOR=vi
export ORACLE_SID=test
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin
umask 022
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
[oracle@node1 ~]$ env | grep NLS_LANG
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
3,客户端所在os的环境变量的nls_lang
我的电脑--属性--环境变量--新建环境变量 NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
这三个参数必须完全一致,才能有效使用中文字符
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29108064/viewspace-1149344/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29108064/viewspace-1149344/