Character Encoding problem?

Question

In my mysql database I have the following information in a page name field.

ç,Ç,ö,Ö,ü,Ü,ı,İ,ş,Ş,ğ,Ğ

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.

"ç,Ç,ö,Ö,ü,Ü,ı,İ,ş,Ş,ğ,Ğ"

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.

Answer 1

You can set client encoding this way:

mysql_connect();
mysql_select_db("database");
mysql_query("SET CHARACTER SET utf8");

Answer 2

No, this code doesn't change your symbols. you do it somewhere else

Edit: now, after your edit, it become clear that you haven't proper encoding set. SET NAMES should help

Answer 3

See this please. You need UTF8 format.