PLSQL更改oracle字符集,设置PL/SQL Developer 字符集

设置PLSQL Developer字符集与Oracle服务器字符集一直

方法1：

1、查询oracle server端的字符集。打开SQL Window输入下面SQL查询服务端的字符集。

select userenv('language') from dual;

2、我的电脑中环境变量界面，在系统变量中新加：

变量名：NLS_LANG

变量值：SIMPLIFIED CHINESE_CHINA.ZHS16GBK

其中的变量值跟服务器查询到得一致即可。

方法2：

Sql代码

SQL>select*fromv$nls_parameters;

PARAMETER                                                        VALUE

---------------------------------------------------------------- ----------------------------------------------------------------

NLS_LANGUAGE                                                     SIMPLIFIED CHINESE

NLS_TERRITORY                                                    CHINA

NLS_CURRENCY                                                     ￥

NLS_ISO_CURRENCY                                                 CHINA

NLS_NUMERIC_CHARACTERS                                           .,

NLS_CALENDAR                                                     GREGORIAN

NLS_DATE_FORMAT                                                  DD-MON-RR

NLS_DATE_LANGUAGE                                                SIMPLIFIED CHINESE

NLS_CHARACTERSET                                                 UTF8

NLS_SORTBINARY

NLS_TIME_FORMAT                                                  HH.MI.SSXFF AM

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                                           UTF8

NLS_COMPBINARY

NLS_LENGTH_SEMANTICS                                             BYTE

NLS_NCHAR_CONV_EXCPFALSESQL> select * from v$nls_parameters;

PARAMETER VALUE

---------------------------------------------------------------- ----------------------------------------------------------------

NLS_LANGUAGE SIMPLIFIED CHINESE

NLS_TERRITORY CHINA

NLS_CURRENCY ￥

NLS_ISO_CURRENCY CHINA

NLS_NUMERIC_CHARACTERS .,

NLS_CALENDAR GREGORIAN

NLS_DATE_FORMAT DD-MON-RR

NLS_DATE_LANGUAGE SIMPLIFIED CHINESE

NLS_CHARACTERSET UTF8

NLS_SORT BINARY

NLS_TIME_FORMAT HH.MI.SSXFF AM

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 UTF8

NLS_COMP BINARY

NLS_LENGTH_SEMANTICS BYTE

NLS_NCHAR_CONV_EXCP FALSE

NLS_LANGUAGE 对应 是SIMPLIFIED CHINESE

最后在我本机环境变量中增加

NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK

这样我再使用plsql就不会再出现乱码了。

其实如果本地安装oracle client一般是不会出现乱码的，由于我本地使用了简单版的oracle client 如果安装oracle client过多臃肿。