存Emoj表情符时，报错。
原因：mysql数据库按3个字节进行编码，表情符是四个字节，存入数据库报错
把表情符替换成空串就可以了
if (nickname != null && !"".equals(nickname)) {
nickname = nickname.replaceAll("[\ud800\udc00-\udbff\udfff\ud800-\udfff]", "");
logger.warn("nickname:" + nickname);
}
另一种方法
相关文章
- java保存繁体字到数据库时就报错Incorrect string value: '\xF0\xA6\x8D\x8B\xE5\xA4...' for column 'name' at row 1
- SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xF0\x9F\x90\xA3\xF0\x9F...' for column
- Django1.10+Mysql 5.7存储emoji表情，报Incorrect string value: '\\xF0\\x9F\\x90\\xA8' for column 'signature' at row 1的解决方法
- java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\xB3' for column 'Content' at row 1
- 解决pymysql.err.InternalError: (1366, "Incorrect string value: '\\xF0\\x9F\\x8C\\xB8' for column 'headline' at row 1")
- [转]java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\x8E' for column 'nick' at row 1
- 用naviact 从 sqlserver 迁移 mysql 报错：[2018-08-08 18:58:48] [Err] 1366 - Incorrect string value: '\xF0\x9F\x92\x8D\xE3\x80...' for column 'pc_content' at row 94
- 解决pymysql.err.InternalError: (1366, "Incorrect string value: '\\xF0\\x9F\\x8C\\xB8' for column 'headline' at row 1")
- java.sql.SQLException: Incorrect string value: '\xF0\x9F\x9A\x80\xF0\x9F...' for column 'name' at row 1
- Incorrect string value: '\xF0\x9F\x93\xB7' for column 'content' at row 1