asked on

inserting Arabic text into oracle using PHP

I am upgrading an old software system ,I have installed Apache 1.3 on a fedora 5 system, I have Oracle 9 on another server and I want to insert ARABIC text into Oracle using PHP 4
the old software is written in Delphi and uses AMERICAN_AMERICA.AR8MSWIN1256 coding for inserting Arabic Data into data base
I have no problem with reading Arabic Data from Oracle ( which have been inserted using Delphi ), but when I want to insert data, ????? is inserted instead of correct text
I have set ENV Variables in my httpd.conf but it didn't work
please help me solving this problem.

Aamir Saeed

Please set your browser encoding as unicode and then try.

Claudia_Presto

ASKER

I have tried this before, but nothing happened
I have set browser encoding to UTF-8, Arabic(windows-1256 ),arabic(Iso-8859-6) , but non of them worked !

Aamir Saeed

what is your field data type?

Claudia_Presto

ASKER

text
char

Aamir Saeed

plz change your field collation to utf8_general_ci

Claudia_Presto

ASKER

I can not change anything in DataBase, I have to use old data base configuration ! any other Idea ?!
I think there is some problem with my Apache or php configuration, because right now we can insert Arabic text into Oracle using Delphi without any problem !

hernst42

Setting the NLS_LANG via httpd.conf does not work for php and oracle correctly. You will need to set the NLS_LANG before executing the httpd-binary. Either do this in your apachectl or std-envvars file.

Also make sure the encoding of your webpage is set accoringly.

Claudia_Presto

ASKER

I opened apachectl file, but I don't know how to add NLS_LANG to apachectl

ASKER CERTIFIED SOLUTION

hernst42

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Claudia_Presto

ASKER

thank you very much
It works great