emo表情插入mysql数据库报错，求助~~~

[呢喃北上]

数据库，表，字段，mysql.ini均设置为utf8mb4编码，项目时ssm搭建，还是报错

uncategorized SQLException for SQL []; SQL state [HY000]; error code [1366]; Incorrect string value: '\xF0\x9F\x98\x83' for column 'rcontext' at row 1; nested exception is java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\x83' for column 'rcontext' at row 1] with root cause
java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\x83' for column 'rcontext' at row 1
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1021)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:62)
at com.sun.proxy.$Proxy33.execute(Unknown Source)

[hongmei85]

错误提示是说往rcontext列插入'\xF0\x9F\x98\x83'出错，看看rcontext列的数据类型

[「已注销」]

表情到后台都是乱码......................................

[呢喃北上]

引用 3楼Web_Rain 的回复:

表情到后台都是乱码......................................

是插不进去啊老哥

[呢喃北上]

引用 1楼hongmei85 的回复:

错误提示是说往rcontext列插入'\xF0\x9F\x98\x83'出错，看看rcontext列的数据类型

varchar类型，utf8mb4编码