java.sql.BatchUpdateException: Incorrect string value: '\xD6\xD0\xB9\xFA\xB9\xA4...' for column 'con

最新推荐文章于 2025-06-04 15:49:19 发布

转载最新推荐文章于 2025-06-04 15:49:19 发布 · 8.1k 阅读

EJB jpa 专栏收录该内容

8 篇文章

订阅专栏

文章详细介绍了在使用MySQL存储包含4字节Unicode字符时遇到的错误，通过检查代码并调整数据库编码成功解决问题的过程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

java.sql.BatchUpdateException: Incorrect string value: '\xD6\xD0\xB9\xFA\xB9\xA4...' for column 'con

今天收到运营的BUG，出现了类似回档的问题

查看了服务器日志，发现持续一段时间数据库抛出异常

[java] view plain copy print ?

<SPAN style="FONT-SIZE: 14px">Caused by: java.sql.BatchUpdateException: Incorrect string value: '\xF0\x9F\x92\x97\xE2\x80...' for column 'innerNotice' at row 1
at com.mysql.jdbc.ServerPreparedStatement.executeBatchSerially(ServerPreparedStatement.java:814)
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1452)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
... 16 more</SPAN>

Caused by: java.sql.BatchUpdateException: Incorrect string value: '\xF0\x9F\x92\x97\xE2\x80...' for column 'innerNotice' at row 1
	at com.mysql.jdbc.ServerPreparedStatement.executeBatchSerially(ServerPreparedStatement.java:814)
	at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1452)
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
	at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
	at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
	... 16 more

但是数据库的字符集是UTF-8的，查询了抛错的字段，也是UTF-8
百度无结果，只能查google

得到的解释如下：

MySQL's utf8 permits only the unicode characters that can be represented with 3 bytes in UTF-8. Here you have a string with a character that needs 4 bytes: \xF0\x90\x8D\x83 (U+10343 GOTHIC LETTER SAUIL).

意思大概是，MySQL的UTF-8只支持3个字节的unicode字符，无法支持四个字节的Unicode字符。

查询了服务器类似的代码，发现了判断MySql支持Unicode字符的方法，大概意思为：

[java] view plain copy print ?

for i=1->n
int c=str.codePointAt(i);
if (c<0x0000||c>0xffff) {
return false;
}

for i=1->n
int c=str.codePointAt(i);
if (c<0x0000||c>0xffff) {
    return false;
}

调用后解决此问题。

附上两个讨论这个问题的地址：

1. 解释来源地址

http://stackoverflow.com/questions/10957238/incorrect-string-value-when-trying-to-insert-utf-8-into-mysql-via-jdbc

2. 4字节Unicode字符的讨论帖

http://topic.youkuaiyun.com/u/20091107/17/c0eb2463-b4bb-4197-bd67-0459db8aa137.html

id int primary key,
name varchar(20),
title varchar(10) character set utf8
);

在测试：

Hibernate: insert into Teacher (name, title, id) values (?, ?, ?)

呵呵，我的问题终于解决了！继续奋斗！！！

不过更有效的方法是把mysql的编码改为gb2312.在重启mysql，但是在改之前创建的数据库的表是没法改变的，就得自己重新创建数据库啦！！！