ITPub博客

首页 > 数据库 > MySQL > Mysql 5.6 support Chinese

Mysql 5.6 support Chinese

原创 MySQL 作者:wiron 时间:2014-03-03 11:47:51 0 删除 编辑
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/,如需转载,请注明出处,否则将追究法律责任。

下一篇: oracle学习路线图
请登录后发表评论 登录
全部评论

注册时间:2013-11-15

  • 博文量
    4
  • 访问量
    31096