• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1117
  • Last Modified:

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.
0
Claudia_Presto
Asked:
Claudia_Presto
  • 5
  • 3
  • 2
1 Solution
 
Aamir SaeedCommented:
Please set your browser encoding as unicode and then try.
0
 
Claudia_PrestoAuthor Commented:
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 !
0
 
Aamir SaeedCommented:
what is your field data type?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Claudia_PrestoAuthor Commented:
text
char
0
 
Aamir SaeedCommented:
plz change your field collation to utf8_general_ci
0
 
Claudia_PrestoAuthor Commented:
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 !
0
 
hernst42Commented:
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.
0
 
Claudia_PrestoAuthor Commented:
I opened apachectl file, but I don't know how to add NLS_LANG to apachectl
0
 
hernst42Commented:
add the following lines before
# --------------------                              --------------------
# ||||||||||||||||||||   END CONFIGURATION SECTION  ||||||||||||||||||||

NLS_LANG=AMERICAN_AMERICA.AR8MSWIN1256
export NLS_LANG

then use apachectl to stop and start the webserver
0
 
Claudia_PrestoAuthor Commented:
thank you very much
It works great
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 5
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now