mysql插入数据含有中文字符报错：Incorrect string value: '\xE5\xBE\xAE\xE5\x8D\x9A...' for column 'app_name' at ...

mysql插入数据含有中文报错，原因是创建表时没有设置DEFAULT CHARSET=utf8 ,mysql就默认编码为latin1

mysql> select * from apps;
+----------+-------------------+---------+
| app_name | url               | country |
+----------+-------------------+---------+
| QQ APP   | http://im.qq.com/ | CN      |
+----------+-------------------+---------+
1 row in set (0.00 sec)

mysql> insert apps values('微博 APP','http://weibo.com/','CN');
ERROR 1366 (HY000): Incorrect string value: '\xE5\xBE\xAE\xE5\x8D\x9A...' for column 'app_name' at row 1

mysql> show create table apps;
+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                                                                                   |
+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------+
| apps  | CREATE TABLE `apps` (
  `app_name` varchar(40) NOT NULL,
  `url` varchar(40) NOT NULL,
  `country` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+-------+----------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

把默认编码字符集改为utf8就不会报错了

mysql> alter table `apps` DEFAULT CHARACTER SET utf8,
modify `app_name` varchar(40) CHARACTER SET utf8 NOT NULL,                                                                      modify `url` varchar(40) CHARACTER SET utf8 NOT NULL,
modify `country` varchar(20) CHARACTER SET utf8 NOT NULL                                                                              
-> ;
Query OK, 1 row affected (0.08 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> show create table apps;
+-------+-------------------------------------------------------------------------------                                                                                -------------------------------------------------------------------------------+
| Table | Create Table                                                                                                                                                                                                                                 |
+-------+-------------------------------------------------------------------------------                                                                                -------------------------------------------------------------------------------+
| apps  | CREATE TABLE `apps` (
  `app_name` varchar(40) NOT NULL,
  `url` varchar(40) NOT NULL,
  `country` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+-------+-------------------------------------------------------------------------------                                                                                -------------------------------------------------------------------------------+
1 row in set (0.00 sec)

此时再插入数据就不会报错了
mysql> insert apps values('微博 APP','http://weibo.com/','CN');
Query OK, 1 row affected (0.01 sec)
mysql> select * from apps;
+------------+-------------------+---------+
| app_name   | url               | country |
+------------+-------------------+---------+
| QQ APP     | http://im.qq.com/ | CN      |
| 微博 APP   | http://weibo.com/ | CN      |
+------------+-------------------+---------+
2 rows in set (0.00 sec)