PL/SQL 阿拉伯语显示为? [英] PL/SQL arabic displayed as?
问题描述
当我在PL/SQL Developer中查询含有阿拉伯语文本的数据时,显示为问号(????).
When I query for data that have arabic text in PL/SQL Developer, It is showed as question marks (????).
我确信数据正确存储在数据库中,因为它正确显示在网站上,也在服务器上.
I am sure the data is correctly stored in DB because it shows on website properly, also on the server.
所以我认为这是与我的 PL/SQL Developer (v8.0.4.1514) 相关的问题.
So I think it is a problem related to my PL/SQL Developer (v8.0.4.1514).
有什么方法可以改变 PL/SQL Developer 显示/编码阿拉伯文本的方式吗?
Is there any way to change how PL/SQL Developer shows/encodes arabic text?
如何检查阿拉伯文本的存储格式/编码?
How to check in what format/encoding the arabic text is stored?
我的问题可能遗漏了一些细节,所以请询问我,并记住我是 PL/SQL 和 SQL 的初学者.
My question might be missing some details, So Just ask me and also keep in mind that I am very beginner in PL/SQL and in SQL.
谢谢.
推荐答案
我找到了一个解决方案(它可能也适用于显示为????
"的其他语言)
I found a solution (which might also work with other languages that shows as '????
')
我将注册表中的 NLS_LANG
更改为 AMERICAN_AMERICA.AL32UTF8
I changed the NLS_LANG
in registry to AMERICAN_AMERICA.AL32UTF8
(我在注册表中发现了 3 个 NLS_LANG
,检查每一个或像我一样将它们全部更改.)
(I found 3 NLS_LANG
's in registry, check with each one or just change them all like I did.)
然后重新启动 PL/SQL 开发人员,测试一个查询,阿拉伯文本显示正常.
then restarted PL/SQL developer, test a query and arabic text is showing normally.
谢谢大家.
这篇关于PL/SQL 阿拉伯语显示为?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!