Incorrect updated Chinese text and PHP, MySql

Question

When I run this sql from the MySql Admin panel:

UPDATE CH_HRA_questions SET question = '稱謂' WHERE q_id = 1

it works correctly, and in the table I can see the correct Chinese characters.

But when I run the same update statement from PHP, I get:

ç¨±è¬‚

The collation of the field is utf8_unicode_ci, any ideas what I'm doing wrong?

Many thanks

change your web page's encoding to UTF-8 – zkanoca Jun 04 '13 at 11:08 — zkanoca, Jun 04 '13 at 11:08

score 1 · Answer 1 · edited May 23 '17 at 11:57

1

Try to set the PHP<->MySQL-connection charset.

If you are using the old MySQL API use mysql_set_charset('utf8_unicode_ci') (more).
If you use the MySQLi API use $mysqli->set_charset('utf8_unicode_ci') (more).

I also found out that $mysqli->query('utf8') can be working (here)...

edited May 23 '17 at 11:57

Community

1
1

answered Jun 04 '13 at 11:03

fnkr

9,428
6
54
61

or run query `SET NAMES UTF8` right after connection established – claustrofob Jun 04 '13 at 11:12

score 0 · Accepted Answer · answered Jun 04 '13 at 11:10

0

$mysqli->set_charset("utf8");

answered Jun 04 '13 at 11:10

zkanoca

9,664
9
50
94

Incorrect updated Chinese text and PHP, MySql

2 Answers2