php mysql汉字无法查询_我无法从MYSQL到PHP获取汉字

I found a lot of answers for my problem but nothing worked.

I have Chinese characters in my MYSQL database and when I SELECT my field in php I get '???' instead of '我们的产品'. I was able to INSERT this characters from php to my MYSQL database.

With characters like 'éà' I have no problem to get them in PHP.

My database, table and field are encoded in utf8_unicode_ci. There is my php file(also encoded in utf-8) :

$query = mysql_query("SELECT * FROM table");

$arr = mysql_fetch_array($query))

echo ($arr['field']);

?>

If I replace my code like this it prints 我们的产品 :

$query = mysql_query("SELECT '我们的产品'");

arr = mysql_fetch_array($query)

echo ($arr[0]);

I hope I gave enough information.

解决方案

set charset as utf8 before making a mysql query, like this

mysql_connect('localhost','mysql_user','your_password');

mysql_select_db('my_db') or die( "Unable to select database");

mysql_set_charset('UTF8');

mysql_query('Your query here');