Character Encoding problem?
Posted
by JasonS
on Stack Overflow
See other posts from Stack Overflow
or by JasonS
Published on 2010-03-29T12:20:10Z
Indexed on
2010/03/29
12:23 UTC
Read the original article
Hit count: 464
Hi,
In my mysql database I have the following information in a page name field.
ç,Ç,ö,Ö,ü,Ü,i,I,s,S,g,G
If I do a phpmyadmin dump the above is exported.
I am using a different php script and instead of the above I am getting this.
"\303\247,\303\207,\303\266,\303\226,\303\274,\303\234,\304\261,\304\260,\305\237,\305\236,\304\237,\304\236"
This is the snippet which is generating the output.
$data_sql = "SELECT * FROM ".$table_name;
$data_res = @mysql_query($data_sql);
while($data_row = @mysql_fetch_array($data_res,MYSQL_NUM))
{
print_r($data_row);
}
How can I modify this to make sure that the data is correct? Is some sort of php function required? Do I need to do something to the file?
Any advice is much appreciated.
© Stack Overflow or respective owner