前言：手机app应用评论的时候，恢复表情符号，提示失败。
?
1，查看tomcat后台日志，核心报错信息如下：
caused by: java.sql.sqlexception: incorrect string value: '\xf0\x9f\x98\x97\xf0\x9f...' for column 'content' at row 1
at com.mysql.jdbc.sqlerror.createsqlexception(sqlerror.java:1074)
at com.mysql.jdbc.mysqlio.checkerrorpacket(mysqlio.java:4096)
at com.mysql.jdbc.mysqlio.checkerrorpacket(mysqlio.java:4028)
at com.mysql.jdbc.mysqlio.sendcommand(mysqlio.java:2490)
at com.mysql.jdbc.mysqlio.sqlquerydirect(mysqlio.java:2651)
at com.mysql.jdbc.connectionimpl.execsql(connectionimpl.java:2734)
at com.mysql.jdbc.preparedstatement.executeinternal(preparedstatement.java:2155)
at com.mysql.jdbc.preparedstatement.execute(preparedstatement.java:1379)
at org.apache.commons.dbcp.delegatingpreparedstatement.execute(delegatingpreparedstatement.java:172)
at org.apache.commons.dbcp.delegatingpreparedstatement.execute(delegatingpreparedstatement.java:172)
at com.ibatis.sqlmap.engine.execution.sqlexecutor.executeupdate(sqlexecutor.java:80)
at com.ibatis.sqlmap.engine.mapping.statement.mappedstatement.sqlexecuteupdate(mappedstatement.java:216)
at com.ibatis.sqlmap.engine.mapping.statement.mappedstatement.executeupdate(mappedstatement.java:94)
... 46 more
[root@mysqlvm2 ~]# mysql -root -p
mysql> use test;
database changed
mysql> show tables;
ignoring query to other database
mysql> ctrl-c -- exit!
aborted
忘记输入-u参数了，冲洗你输入，ok，如下所示：
[root@mysqlvm2 ~]# mysql -uroot -p
enter password:
welcome to the mysql monitor. commands end with ; or \g.
your mysql connection id is 4
server version: 5.6.12-log source distribution
copyright (c) 2000, 2011, oracle and/or its affiliates. all rights reserved.
oracle is a registered trademark of oracle corporation and/or its
affiliates. other names may be trademarks of their respective
owners.
type 'help;' or '\h' for help. type '\c' to clear the current input statement.
mysql>
mysql> use test;
database changed
mysql> show tables;
+------------------------+
| tables_in_test |
+------------------------+
| c |
| lubin_test |
| test |
| tt |
+------------------------+
10 rows in set (0.00 sec)
这种输入incorrect string value: '\xf0\x9f\x98\x97\xf0\x9f...'的问题，多数都是字符集的，以前从latain改成gbk，从gbk改成utf8，而我的content字段已经utf8了，那么比utf8更多的就只有utf8mb4了，所以去修改表字段的字符集吧。
mysql>
2，先去修改表字段字符集为utf8mb4：
alter table ugc_review_content modify `content` text character set utf8mb4 collate utf8mb4_unicode_ci comment '评论内容';
执行完后，再在手机端的app测试，依然报同样的错误。
3，再去修改表字符集utf8mb4：
alter table ugc_review_content charset=utf8mb4 comment='晒单/推荐的评论内容';
执行完后，再在手机端的app测试，依然报同样的错误。
4，再去修改数据库的字符集utf8mb4:
vim my.cnf
init-connect='set names utf8mb4'
character-set-server=utf8mb4
重启mysql数据库
[root@mysqlvm4 ~]# service mysql restart
shutting down mysql.... [确定]
starting mysql.............................................[确定]..
[root@mysqlvm4 ~]#
查看db的字符集
mysql> show variables like '%char%';
+--------------------------+----------------------------------+
| variable_name | value |
+--------------------------+----------------------------------+
| character_set_client | utf8mb4 |
| character_set_connection | utf8mb4 |
| character_set_database | utf8mb4 |
| character_set_filesystem | binary |
| character_set_results | utf8mb4 |
| character_set_server | utf8mb4 |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/mysql/share/charsets/ |
+--------------------------+----------------------------------+
8 rows in set (0.00 sec)
mysql>
在手机app端重新评论，输入表情符号，点击提交提示评论成功。
5，问题分析总结：
㈠ 原因
普通的字符串或者表情都是占位3个字节，所以utf8足够用了，但是移动端的表情符号占位是4个字节，普通的utf8就不够用了，为了应对无线互联网的机遇和挑战、避免 emoji 表情符号带来的问题、涉及无线相关的 mysql 数据库建议都提前采用 utf8mb4 字符集，这必须要作为移动互联网行业的一个技术选型的要点
㈡ 限制
需要 >= mysql 5.5.3版本、从库也必须是5.5的了、低版本不支持这个字符集、复制报错。
参考文章地址：http://bbs.csdn.net/topics/390055415