Background:
After default installation, my DB do not support Chinese, can not insert Chinese into tables.
Sym
mysql> insert into news values(,'雾霾',"","");
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 ''雾霾',"","")' 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,"雾霾","","");
Query OK, 1 row affected (0.05 sec)
mysql> insert into news(news_title,news_curl) values("青春","");
Query OK, 1 row affected (0.08 sec)
mysql> select * from news;
+---------+------------+-----------+-----------------+
| news_id | news_title | news_desc | news_curl |
+---------+------------+-----------+-----------------+
| 1 | fog | | |
| 2 | 雾霾 | | |
| 3 | 青春 | NULL | |
+---------+------------+-----------+-----------------+
3 rows in set (0.00 sec)
mysql>
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/167471/viewspace-1098484/
,如需转载,请注明出处,否则将追究法律责任。