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