PL/SQL Developer 8.0.4在Windows 2008上中文乱码的解决方法

1、首先检查服务器设置

执行语句

select * from v$nls_parameters

 

执行结果
SQL> 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                                                 ZHS16GBK
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                                           AL16UTF16
NLS_COMP                                                         BINARY
NLS_LENGTH_SEMANTICS                                             BYTE
NLS_NCHAR_CONV_EXCP                                              FALSE
 
19 rows selected

可以看到语言设置为SIMPLIFIED CHINESE，字符集为ZHS16GBK

 

2、设置本地环境变量

右击我的电脑->属性->高级系统设置->高级->环境变量，添加2个项目

LANG=zh_CN.GBK

NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK

效果如下图：

3、检查PL/SQL Developer显示字体是否已经设置为中文字体

进入PL/SQL Developer，打开工具菜单->首选项->用户界面->字体，查看各项是否已经设置为中文字体

4、PL/SQL Developer重新连接，查看是否已经可以显示中文。