Mysql 5.6 support Chinese

Background: 
After default installation, my DB do not support Chinese, can not insert Chinese into tables.
Sym
mysql> insert into news values(,'雾霾',"","www.sina.com.cn");
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''雾霾',"","www.sina.com.cn")' at line 1
mysql>

Solution:
mysql> alter table news convert to character set utf8;
Query OK, 1 row affected (0.74 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> insert into news values(2,"雾霾","","www.sina.com.cn");
Query OK, 1 row affected (0.05 sec)

mysql> insert into news(news_title,news_curl) values("青春","www.sohu.com");
Query OK, 1 row affected (0.08 sec)

mysql> select * from news;
+---------+------------+-----------+-----------------+
| news_id | news_title | news_desc | news_curl       |
+---------+------------+-----------+-----------------+
|       1 | fog        |           | www.163.com     |
|       2 | 雾霾       |           | www.sina.com.cn |
|       3 | 青春       | NULL      | www.sohu.com    |
+---------+------------+-----------+-----------------+
3 rows in set (0.00 sec)

mysql>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/167471/viewspace-1098484/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/167471/viewspace-1098484/