Page 1 of 1
utf-8 issue
Posted: Mon Feb 22, 2010 1:45 am
by zahidiqbalbscs
Hi,
I am getting very strange thing,
id title
179 ??????????
180 ??????????
181 اسفسدفسداف
the column titile = utf8_general_ci and its data type is text
when i try to input arabic from front end form then it generets "??????" and if i try to input from query manually then it works perfect.
May i know where i am wrong
Re: utf-8 issue
Posted: Mon Feb 22, 2010 5:12 am
by Apollo
What kind of encoding does your front end use? What is the collation of your SQL connection?
And when you say "it generates ????", where/how do you inspect that?
Re: utf-8 issue
Posted: Wed Oct 06, 2010 1:31 am
by edaili
Hello
Im having a similiar problem
I am trying to retrieve data from oracle into PHP and I have successfully accomplished that, but the data appeared in question marks (??????), so I add the AMERICAN_AMERICA.AR8MSWIN1256 to NLS language in the registry for oracle and now the data appears as (ÓÇãÑ ÝíáíÈ ÚíÏ ÇáÚÏíáí). I tried encoding and all suggested character sets from IE and from the PHP code but had no results. I tried Windows-1256, UTF-8 & 16, I would appreciate some support for this issue
By the way anything else in the page that is not generated from the database and written in arabic appears in arabic OK with no problems so i have no problem with that, only with what is generated from the database.
windows-1256 generates (ÓÇãÑ ÝíáíÈ ÚíÏ ÇáÚÏíáí)
UTF-8 generates (����� � ����� )
Thank you