PL/SQL Developer 远程连接Oracle数据库-优快云博客

本文指导如何在pl/sql developer环境下配置环境变量NLS_LANG为SIMPLIFIED CHINESE_CHINA.ZHS16GBK，解决Oracle数据库中文乱码问题。通过一系列步骤，包括下载并安装pl/sqlDeveloper和Oracle instantclient，设置环境变量，重新启动pl/sql developer，确保检索中文内容不再显示乱码。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.先下载个[b][color=blue]pl/sql Developer[/color][/b] 百度，谷歌下就能找到
2.下载Oracle安装包[b][color=blue]instantclient-basic-win32-11.2.0.1.0.zip[/color][/b]（网盘地址[url]http://yunpan.cn/Qid3SQ32EcWZt[/url] 访问密码 1a82）

操作图依次为：
[img]http://dl.iteye.com/upload/picture/pic/130123/923d4718-d1a9-34eb-9353-a111d2ba9470.jpg[/img]

[img]http://dl.iteye.com/upload/picture/pic/130125/2929c5b6-6129-3902-9eb0-fcde76ac47b2.jpg[/img]

[img]http://dl.iteye.com/upload/picture/pic/130129/6c889b08-fec2-30d0-a870-574680b9b1e9.jpg[/img]

[img]http://dl.iteye.com/upload/picture/pic/130127/aba1c373-1fab-3db7-bffe-b214e613af1b.jpg[/img]

[size=medium]内容文本信息：[/size]


LISTENER_ORCL =

  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

ORACLR_CONNECTION_DATA =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

    )

    (CONNECT_DATA =

      (SID = CLRExtProc)

      (PRESENTATION = RO)

    )

  )

nmb =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.156)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl)

    )
  )

能连接上之后又出现新的问题 [color=blue]中文乱码[/color]，[color=blue]原因是数据库的字符集和客户端的字符集不一致造成的[/color]，

[b][color=blue]使用如下sql 查询数据库的字符集[/color][/b]

select userenv('language') from dual;

结果是：
AMERICAN_AMERICA.ZHS16GBK

[b][color=blue]解决方案如下：[/color][/b]

在windows中创建一个系统环境变量，设置如下：
[color=red]"NLS_LANG"="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"[/color]
“SIMPLIFIED CHINESE_CHINA.ZHS16GBK”，然后重新启动 pl/sql developer，这样检索出来的中文内容就不会是乱码了。