启动PL/SQL Developer 报字符编码不一致错误

最新推荐文章于 2020-11-11 14:32:12 发布
原创 最新推荐文章于 2020-11-11 14:32:12 发布 · 1.5k 阅读 · 0 ·
本内容遵循CC 4.0 BY-SA版权协议
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文介绍了解决Oracle数据库中服务器字符集与客户端字符集不一致导致的问题的方法。通过修改注册表中的NLS_LANG键值，将客户端字符集从ZHS16GBK更改为AL32UTF8以匹配数据库字符集。

错误如下：

Database character set (AL32UTF8) and Client character set (ZHS16GBK) are different.
Character set conversion may cause unexpected results.

Note: you can set the client character set through the NLS_LANG environment variable or the NLS_LANG registry key in
HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/KEY_Oracle_10g.

打开注册表,通过命令regedit。找到到文中提示的路径，发现NLS_LANG键的值为:

SIMPLIFIED CHINESE_CHINA.ZHS16GBK

修改为：SIMPLIFIED CHINESE_CHINA.AL32UTF8即可

标签
#character #database #oracle
sabic
关注
PL/SQL database character set(AL32UTF8) and Client character set(ZHS16GBK) are different
weixin_30765505的博客
05-16 256
转自：http://blog.163.com/magicc_love/blog/static/18585366220123111128283/ 修改部分为红色部分，原作者写错了 启动PL/SQL Developer 报字符编码不一致错误 Database character set (AL32UTF8) and Client character set (ZHS16GBK) ar...
PL/SQL错误提示 database character set(AL32UTF8) and Client character set(ZHS16GBK) are different
huimengshao的专栏
06-01 1万+
Database character set (AL32UTF8) and Client character set (ZHS16GBK) are different. Character set conversion may cause unexpected results. Note: you can set the client character set through the NLS
切换 ORACLE 客户端字符集
心想事成
12-26 701
切换 ORACLE 客户端字符集 如果我们需要连接不同的数据库，而这些数据库又有不同的字符集，在登录 plsql developer 时会有提示：   Database characterset (AL32UTF8) and Client character set (ZHS16GBK) are different. Character setconversion may caus
PLSQL Developer链接时报错Database character set (AL32UTF8) and Client character set (ZHS16GBK) are differ
GengJL
11-11 793
1、问题 Database character set (AL32UTF8) and Client character set (ZHS16GBK) are different. Character set conversion may cause unexpected results. Note: you can set the client character set through the NLS_LANG environment variable or the NLS_LANG registry k
plsql 登录后，提示数据库字符集（AL32UTF8）和客户端字符集（ZHS16GBK）不一致
热门推荐
学习专栏
07-29 2万+
plsql 登录后提示： Database character set (AL32UTF8) and Client character set (ZHS16GBK) are different. Character set conversion may cause unexp
启动PL/SQL Developer 报字符编码不一致错误 ,Database character set (AL32UTF8)
funnsy的专栏
02-13 1051
Database character set (AL32UTF8) and Client character set (ZHS16GBK) are different. Character set conversion may cause unexpected results.  Note: you can set the client character set through the NLS
启动PL/SQL Developer的过程中，发现 报字符编码不一致错误
iteye_6692的博客
11-09 173
http://blog.csdn.net/lifuxin1125/article/details/7886025
启动PL/SQL Developer 报字符编码不一致错误,Database character set
conggeng4051的博客
12-08 155
Database character set (AL32UTF8) and Client character set (ZHS16GBK) are different.Character set conversion may c...
启动PL/SQL Developer 报字符编码不一致错误 ,Database character set (AL3...
shuangyan5230的专栏
06-03 476
Database character set (AL32UTF8) and Client character set (ZHS16GBK) are different.Character set conversion may cause unexpected results.Note: you can set the client character set through the NLS_L
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值