导致\xf0\x9f\x98\x94字符串值不正确的sql异常?

vof42yt1  于 2021-06-20  发布在  Mysql
关注(0)|答案(1)|浏览(400)

日志中有以下错误。将字符串\xf0\x9f\x98\x94作为参数传递时发生错误。无法将此值保存到表中,因此它抛出错误的字符串值错误。我想知道是什么原因传递了这样的价值观。是黑客攻击吗?当作为post form param传递时,我不知道\xf0\x9f\x98\x94是什么意思。谢谢你的帮助!谢谢!

ERROR 2018-08-19 16:14:40,369 [ajp-bio-8109-exec-2808] util.JDBCExceptionReporter: Incorrect string value: '\xF0\x9F\x98\x94 B...' for column 'body' at row 1
ERROR 2018-08-19 16:14:40,372 [ajp-bio-8109-exec-2808] events.PatchedDefaultFlushEventListener: Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: could not update: [EventEmailDraft#42]
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\x94 B...' for column 'body' at row 1
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4098)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4030)
    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:2677)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2134)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2434)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2352)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2337)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    ... 3 more
ERROR 2018-08-19 16:14:40,377 [ajp-bio-8109-exec-2808] errors.GrailsExceptionResolver: SQLException occurred when processing request: [POST] /roadrace/message/saveDraft
Incorrect string value: '\xF0\x9F\x98\x94 B...' for column 'body' at row 1. Stacktrace follows:
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not update: [EventEmailDraft#42]; uncategorized SQLException for SQL [update event_email_draft set version=?, body=?, emails=?, event_id=?, subject=? where id=? and version=?]; SQL state [HY000]; error code [1366]; Incorrect string value: '\xF0\x9F\x98\x94 B...' for column 'body' at row 1; nested exception is java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\x94 B...' for column 'body' at row 1
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: Incorrect string value: '\xF0\x9F\x98\x94 B...' for column 'body' at row 1
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4098)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4030)
    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:2677)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2134)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2434)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2352)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2337)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    at org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105)
    ... 3 more
ndh0cuux

ndh0cuux1#

这是由3个以上字节组成的unicode序列

groovy:000> new String([0xF0, 0x9F, 0x98, 0x94] as byte[], 'UTF-8')
===> ?

mysql中utf-8的默认值是只容纳3个字节。
这里可以找到一个恰当的解释,utf8mb4和utf8字符集在mysql中有什么区别?接下来的问题,如“我该如何改变这一点”在这里也得到了回答。

相关问题