CODEWITHSUNDEEP
phpmysqlcharacter-encoding
chokichoc
chokichoc

Reputation: 23

I can't get Chinese characters from MYSQL to 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) :

<meta http-equiv="Content-type" content="text/html; charset=utf-8" />
<?php
$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.

Upvotes: 2

Views: 2337

Answers (1)

dav
dav

Reputation: 9267

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');

Upvotes: 2

Related Questions