how to insert Arabic text to oracle database?

0
votes

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!

1
phphtmlcharacter-encodingoracle11g

1 Answers

0
votes

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