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: 447

Filed under:
|
|

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

Related posts about mysql

Related posts about php