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>