Navicat连接Oracle数据库失败，提示“unsupported server charset ZHS16GBK”的解决方法

一时失言乱红尘 2022-06-10 04:23 287阅读 0赞

Navicat 版本:Navicat Premium 9.1.11

Oracle 版本: Oracle Database 10g Release 2 (10.2.0.1.0)

如下图,使用Navicat连接Oracle数据库失败

![17716501baa1cd114a72ac80b912c8fcc1ce2dfd.jpg][]

问题原因:

Navicat自带的OCI.dll不支持GBK字符集.

以下是Oracle官网上的一段说明

[http://www.oracle.com/technetwork/topics/winsoft-085727.html][http_www.oracle.com_technetwork_topics_winsoft-085727.html]

Version 10.2.0.5

Instant Client Package - Basic:All files required to run OCI, OCCI, and JDBC-OCI applications

instantclient-basic-win32-10.2.0.5.zip(34,846,661 bytes)

\*Instant Client Package - Basic Lite:Smaller version of the Basic, with only English error messages and Unicode, ASCII, and Western European character set support (10.2 only)

instantclient-basiclite-win32-10.2.0.5.zip(10,670,287 bytes)

注意红色部分,lite版的OCI只支持unicode、ascii和西文字符集,这个Navicat提示的不支持GBK字符集相吻合,因此可以推测Navicat不支持GBK的根源在于OCI.dll用的是lite版的,

解决方法：

下载一个非lite版的OCI就可以了

下载地址: [http://www.oracle.com/technetwork/topics/winsoft-085727.html][http_www.oracle.com_technetwork_topics_winsoft-085727.html]

下载链接: [http://download.oracle.com/otn/nt/instantclient/10205/instantclient-basic-win32-10.2.0.5.zip][http_download.oracle.com_otn_nt_instantclient_10205_instantclient-basic-win32-10.2.0.5.zip]

将下载好的 [instantclient-basic-win32-10.2.0.5.zip][http_download.oracle.com_otn_nt_instantclient_10205_instantclient-basic-win32-10.2.0.5.zip]解压到Navicat的安装目录,替换原来的文件

然后打开 Navicat --> 工具 --> 选项 --> 其他 --> OCI,在"OCI library (oci.dll)"中选择刚才解压的文件夹中的oci.dll即可.

转自:http://hi.baidu.com/451425461/blog/item/fa6382d2792da3203af3cf80.html

[17716501baa1cd114a72ac80b912c8fcc1ce2dfd.jpg]: /images/20220610/fa68f2ac2ff04f0bbf071b274b978b0e.png
[http_www.oracle.com_technetwork_topics_winsoft-085727.html]: http://www.oracle.com/technetwork/topics/winsoft-085727.html
[http_download.oracle.com_otn_nt_instantclient_10205_instantclient-basic-win32-10.2.0.5.zip]: http://download.oracle.com/otn/nt/instantclient/10205/instantclient-basic-win32-10.2.0.5.zip