MySQL Forums
Forum List  »  Quality Assurance

Re: Chinese Characters in mysql ?
Posted by: Bernt Johnsen
Date: February 15, 2013 07:43AM

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>

Options: ReplyQuote


Subject
Views
Written By
Posted
11149
January 31, 2013 03:47AM
Re: Chinese Characters in mysql ?
20315
February 15, 2013 07:43AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.