CODEWITHSUNDEEP
phpmysqlcharacter-encoding
ComputerUser
ComputerUser

Reputation: 4888

Character Encoding problem?

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.

Upvotes: 2

Views: 521

Answers (2)

MartyIX
MartyIX

Reputation: 28676

You can set client encoding this way:

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

Upvotes: 1

Your Common Sense
Your Common Sense

Reputation: 157989

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

Upvotes: 0

Related Questions