emoji表情存入varchar类型的字段报错
emoji表情存入varchar类型的字段报错信息如下:
Cause: java.sql.SQLException: Incorrect string value: ‘\xF0\x9F\x98\x82’ for column ‘title’ at row 1
; uncategorized SQLException; SQL state [HY000]; error code [1366]; Incorrect string value: ‘\xF0\x9F\x98\x82’ for column ‘title’ at row 1; nested exception is java.sql.SQLException: Incorrect string value: ‘\xF0\x9F\x98\x82’ for column ‘title’ at row 1] with root cause
java.sql.SQLException: Incorrect string value: ‘\xF0\x9F\x98\x82’ for column ‘title’ at row 1
解决方法:将表中对应字段的字符集设置为utf8mb4 ; 排序规则:utf8mb4_general_ci