如何将阿拉伯文字插入到oracle数据库中？ [英] how to insert Arabic text to oracle database?

问题描述

我将html + php应用程序连接到oracle数据库11g。我试图通过表单插入阿拉伯字符，它显示????的问题。

我上网查找解决方案，但现在没有任何工作！请给予我不同的帮助！

我的环境：
$ b

• Windows 7家庭高级版


• html charset设置为utf8（我试过windows-1256，windows-1252也没有用）


• 注册表NLS_LANG设置为AMERICAN_AMERICA.AR8MSWIN1256


• oracle 11g表列设置为NVARCHAR2


• oracle字符集为WE8MSWIN1252
$注意：通过 SQL DEVELOPER 插入数据时，阿拉伯字符正确显示。 strong>，知道SQL Developer编码设置为 windows-1256




谢谢



编辑：
我将oracle字符集更改为al32utf8，并且仍然是相同的问题！

解决方案

尝试将数据库字符集设置为UTF-8。
这是最接近的来源，所以也许它应该工作。




I have html + php application connected to oracle database 11g. I am trying to insert Arabic characters via form, The issue it shows "????"

I surfed the internet to find a solution, and I did almost every trick but nothing works until now!! please I am disparate for help!

My environment:

• Windows 7 home premium
• html charset is set to utf8 ( I tried windows-1256, windows-1252 also did not work)
• registry NLS_LANG is set to AMERICAN_AMERICA.AR8MSWIN1256
• oracle 11g the table columns are set to NVARCHAR2
• oracle character set is WE8MSWIN1252

Note: Arabic characters displays correctly when data is inserted via SQL DEVELOPER, knowing that SQL Developer encoding is set to windows-1256

Thanks

EDIT: I changed oracle character set to al32utf8, and still same issue!

解决方案

Try setting the database charset to UTF-8. This is the closest to the source so maybe it should be working then.

这篇关于如何将阿拉伯文字插入到oracle数据库中？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！