plsql中文乱码解决方案
<p align="left" style="border:0px;list-style:none;line-height:18pt;color:rgb(50,62,50);font-family:simsun;font-size:14px;"> <p style="border:0px;list-style:none;line-height:21px;color:rgb(50,50);font-family:simsun;font-size:14px;text-indent:20.25pt;"> <span style="line-height:30px;font-size:20px;"><span lang="en-us" style="line-height:30px;font-family:Helvetica,sans-serif;" xml:lang="en-us">PLSQL<span style="line-height:30px;font-family:'宋体';">中文显示乱码,可能是<span lang="en-us" style="line-height:30px;font-family:Helvetica,sans-serif;" xml:lang="en-us">oracle<span style="line-height:30px;font-family:'宋体';">客户端和服务器端的编码方式不一样。网上有很多帖子介绍解决方法,但都说得不清不楚的,这里我将自己经过实践和理解的真正的解决方案分享给大家。 <p style="border:0px;list-style:none;line-height:21px;color:rgb(50,50);font-family:simsun;font-size:14px;text-indent:20.25pt;"> <span style="line-height:30px;font-size:20px;"><span style="line-height:30px;font-family:'宋体';">在这里,我们使用的是服务器上的<span lang="en-us" style="line-height:30px;" xml:lang="en-us">Oracle<span style="line-height:30px;font-family:'宋体';">,不是本机的<span lang="en-us" style="line-height:30px;" xml:lang="en-us">Oracle<span style="line-height:30px;font-family:'宋体';">,按照以下两个步骤进行:首先要查询<span lang="en-us" style="line-height:30px;" xml:lang="en-us">ORACLE<span style="line-height:30px;font-family:'宋体';">服务器的语言、地域和字符集,然后将查询结果设置为本地的环境变量:<span lang="en-us" style="line-height:30px;" xml:lang="en-us">NLS_LANG<span style="line-height:30px;font-family:'宋体';">。具体如下: <p style="border:0px;list-style:none;line-height:21px;color:rgb(50,50);font-family:simsun;font-size:14px;text-indent:20.25pt;"> <span style="line-height:30px;font-size:20px;"><span lang="en-us" style="line-height:30px;color:#FF0000;" xml:lang="en-us">1.?<span style="line-height:30px;font-family:'宋体';color:#FF0000;">查询<span lang="en-us" style="line-height:30px;color:#FF0000;" xml:lang="en-us">ORACLE<span style="line-height:30px;font-family:'宋体';color:#FF0000;">服务器的语言、地域和字符集 <p style="border:0px;list-style:none;line-height:21px;color:rgb(50,50);font-family:simsun;font-size:14px;text-indent:20.25pt;"> <span style="line-height:30px;font-size:20px;"><span lang="en-us" style="line-height:30px;" xml:lang="en-us">select * from nls_database_parameters; <p style="border:0px;list-style:none;line-height:21px;color:rgb(50,50);font-family:simsun;font-size:14px;text-indent:20.25pt;"> <span style="line-height:30px;font-size:20px;"><span style="line-height:30px;font-family:'宋体';color:rgb(51,51,51);">查询结果如下图<span lang="en-us" style="line-height:30px;" xml:lang="en-us">, <p style="border:0px;list-style:none;line-height:21px;color:rgb(50,50);font-family:simsun;font-size:14px;"> <span style="line-height:30px;font-size:20px;"><span style="line-height:30px;font-family:'宋体';color:rgb(51,51);">下图<span lang="en-us" style="line-height:30px;" xml:lang="en-us">NLS_LANGUAGE?<span style="line-height:30px;font-family:'宋体';color:rgb(51,51);">表示“语言”,<span lang="en-us" style="line-height:30px;" xml:lang="en-us">NLS_TERRITORY??<span style="line-height:30px;font-family:'宋体';color:rgb(51,51);">表示“地域”,<span lang="en-us" style="line-height:30px;" xml:lang="en-us">NLSCHARACTSET?<span style="line-height:30px;font-family:'宋体';color:rgb(51,51);">表示“字符集”,将他们三个按照“<span style="line-height:30px;font-family:'宋体';">语言<span lang="en-us" style="line-height:30px;" xml:lang="en-us"><span style="line-height:30px;font-family:'宋体';">地域<span lang="en-us" style="line-height:30px;" xml:lang="en-us">.<span style="line-height:30px;font-family:'宋体';">字符集<span style="line-height:30px;font-family:'宋体';color:rgb(51,51);">”的格式拼接起来,就有了“<span lang="en-us" style="line-height:30px;" xml:lang="en-us">AMERICAN_AMERICA.ZHS16GBK<span style="line-height:30px;font-family:'宋体';color:rgb(51,51);">”(注意:这里要根据你自己的<span lang="en-us" style="line-height:30px;" xml:lang="en-us">ORACLE<span style="line-height:30px;font-family:'宋体';color:rgb(51,51);">服务器的这三个值进行拼接哦<span lang="en-us" style="line-height:30px;" xml:lang="en-us">~<span style="line-height:30px;font-family:'宋体';color:rgb(51,51);">不要简单的复制粘贴) <p style="border:0px;list-style:none;line-height:21px;color:rgb(50,51);"><a href="http://photo.blog.sina.com.cn/showpic.html#blogid=476c81d60101a049&url=http://s3.sinaimg.cn/orignal/476c81d6gdf96738dca02" rel="nofollow" style="text-decoration:none;color:rgb(117,39);"> <img src="https://www.52php.cn/res/2019/01-10/21/89e16931b95197df7c13f1a1042b7a5c.jpg" width="535" height="521" name="image_operate_76421371737221654" alt="PLSQL中文显示乱码,真正有效的解决方案(详细步骤和说明? <p style="border:0px;list-style:none;line-height:21px;color:rgb(50,50);font-family:simsun;font-size:14px;"> <span lang="en-us" style="line-height:21px;" xml:lang="en-us"><span style="line-height:30px;font-size:20px;">? <p style="border:0px;list-style:none;line-height:21px;color:rgb(50,50);font-family:simsun;font-size:14px;"> <span style="line-height:30px;font-size:20px;"><span lang="en-us" style="line-height:30px;color:#FF0000;" xml:lang="en-us">2.<span style="line-height:30px;font-family:'宋体';color:#FF0000;">设置本地环境变量<span lang="en-us" style="line-height:30px;color:#FF0000;" xml:lang="en-us">:NLS_LANG<span style="line-height:30px;font-family:'宋体';color:#FF0000;">, <p style="border:0px;list-style:none;line-height:21px;color:rgb(50,50);font-family:simsun;font-size:14px;"> <span style="line-height:30px;font-size:20px;"><span style="line-height:30px;font-family:'宋体';">进入?<span style="line-height:30px;font-family:'宋体';">我的电脑<span lang="en-us" style="line-height:30px;" xml:lang="en-us">,<span style="line-height:30px;font-family:'宋体';">属性<span lang="en-us" style="line-height:30px;" xml:lang="en-us">,<span style="line-height:30px;font-family:'宋体';">高级<span lang="en-us" style="line-height:30px;" xml:lang="en-us">,<span style="line-height:30px;font-family:'宋体';">环境变量<span lang="en-us" style="line-height:30px;" xml:lang="en-us">,<span style="line-height:30px;font-family:'宋体';">添加<span lang="en-us" style="line-height:30px;" xml:lang="en-us">1<span style="line-height:30px;font-family:'宋体';">项<span lang="en-us" style="line-height:30px;" xml:lang="en-us">: <p style="border:0px;list-style:none;line-height:21px;color:rgb(50,50);font-family:simsun;font-size:14px;"> <span lang="en-us" style="line-height:21px;" xml:lang="en-us"><span style="line-height:30px;font-size:20px;">?NLS_LANG="AMERICAN_AMERICA.ZHS16GBK" <p style="border:0px;list-style:none;line-height:21px;color:rgb(50,51);">(注意:这里要根据你的<span lang="en-us" style="line-height:30px;" xml:lang="en-us">ORACLE<span style="line-height:30px;font-family:'宋体';color:rgb(51,51);">不要复制粘贴) <p style="border:0px;list-style:none;line-height:21px;color:rgb(50,50);font-family:simsun;font-size:14px;">
网上很多方案说要修改本地注册表中的“SOFTWARE->ORACLE->KEY_OraClient11g_home1 (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |