Re: Chinese Characters in mysql ?

[Bernt Johnsen]

It works perfectly all right, but you have to set the character set and collation of the table BEFORE you insert any chinese characters.

E.g:

mysql> create table foo (v varchar(10)) CHARACTER SET utf8 COLLATE utf8_general_ci;
Query OK, 0 rows affected (0.00 sec)

mysql> insert into foo values('太原星河湾酒店'); Query OK, 1 row affected (0.00 sec)

mysql> select * from foo;
+-----------------------+
| v |
+-----------------------+
| 太原星河湾酒店 |
+-----------------------+
1 row in set (0.00 sec)

mysql>