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屋！