java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_c

最新推荐文章于 2025-03-18 20:30:00 发布

nicedaych

最新推荐文章于 2025-03-18 20:30:00 发布

阅读量5.4k

点赞数 3

分类专栏： mybatis 文章标签： sql 数据库

本文链接：https://blog.youkuaiyun.com/nicedaych/article/details/106128093

版权

当使用MyBatis向数据库插入数据时，遇到`java.sql.SQLException`，错误提示涉及latin1_swedish_ci和utf8mb4_general_ci字符集不匹配。解决方法包括修改表的编码、检查表的编码信息以及collation排序规则。调整后可成功插入数据。

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

java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation ‘=’

在使用mybatis向数据库中插入数据时报此错误信息，通过报错信息可以看到是字符编码混淆。

<insert id="addEmp" parameterType="com.mytest.mybatis.entity.Employee">
    insert into tbl_employee ( last_name, email, gender, age) values

最低0.47元/天解锁文章

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

nicedaych

关注关注

3
点赞
踩
4

收藏

觉得还不错? 一键收藏
0
评论
分享

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

专栏目录

utf8mb4_general_ci Cause: java.sql.SQLException: Illegal mix of collations (utf8mb4_general_ci,IMPLI

CarloPan的博客

10-10

2147

org.springframework.jdbc.UncategorizedSQLException: ### Error querying database. Cause: java.sql.SQLException: Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=' ### The error may involve defaul...

如何解决Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (gbk_chinese_ci,IMPLICIT)的问题

逍遥友的专栏

10-28

5237

在执行以下SQL语句时 sql = "select reject_id, rejectdate,rejectreason, receivedocdate, receivedoctime from rejectprj where fhbh=(selectfhbh from reviewprj where id=?) order by reject_id desc " ; 出现以下错误： Ill

参与评论您还未登录，请先登录后发表或查看评论

java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,C

weixin_43564627的博客

07-04

4084

java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation ‘=’，意思是说字符编码不一样，不能进行比较，也就是说数据库内部的编码都不一样，有的数据是latin1_swedish_ci,有的数据是utf8_gen...

解决MySQL字符集冲突引发的“Illegal mix of collations”错误

uncle_ll的博客

03-18

937

解决字符集冲突

java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,...

weixin_30906425的博客

06-23

661

java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='，意思是说字符编码不一样，不能进行比较，也就是说数据库内部的编码都不一样，有的数据是latin1_swedish_ci,有的数据是utf8_gen...

SQL语句报错：java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_g

浮生未歇的博客

05-09

1502

错误截图发生错误的原因：sql语句中有中文条件，查询的表中，表的编码不一致，导致出现这个错误解决方案：先查看所有表的结构与编码是否一致：show full columns from zx_log_manage 修改表现在的编码 ALTER TABLE `表名`convert to character set utf8mb4; utf8mb4:是你要设置的编码，我这里是utfmb4 ...

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci

dajiangqingzhou的专栏

10-20

1010

报错太长，题目容不下： Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'like' SET collation_connection = 'utf8_general_ci'; ALTER DATABASE your_database_name CHARACTER SET utf8 COLLATE utf8_general_ci.

SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (gb231...

weixin_30301449的博客

08-04

5488

SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (gb2312_chinese_ci,COERCIBLE) for operation '=' 在操作MySQL数据库时，报“ error code [12...

解决Mysql：Illegal mix of collations (gbk_chinese_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

热门推荐

hi0000012345的专栏

05-26

1万+

发现是字符集的问题 首先、查看mysql的my.cnf,确认为utf8 mysql> show variables like "%char%"; +--------------------------+-------------------------------------+ | Variable_name | Value | +-----

2025-04-02 09:19:12.680 WARN 14624 --- [nio-5000-exec-2] o.h.engine.jdbc.spi.SqlExceptionHelper : SQL Error: 1267, SQLState: HY000 2025-04-02 09:19:12.680 ERROR 14624 --- [nio-5000-exec-2] o.h.engine.jdbc.spi.SqlExceptionHelper : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation '=' 2025-04-02 09:19:12.805 ERROR 14624 --- [nio-5000-exec-2] o.a.c.c.C.[.[.[.[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [/api] threw exception [Request processing failed; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not extract ResultSet] with root cause java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation '=' at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:127) ~[mysql-connector-java-8.0.11.jar:8.0.11] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95) ~[mysql-connector-java-8.0.11.jar:8.0.11] at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.11.jar:8.0.11] at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:960) ~[mysql-connector-java-8.0.11.jar:8.0.11] at com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1019) ~[mysql-connector-java-8.0.11.jar:8.0.11] at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) ~[HikariCP-3.4.2.jar:na] at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) ~[HikariCP-3.4.2.jar:na] at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57) ~[hibernate-core-5.4.12.Final.jar:5.4.12.Final] at org.hibernate.loader.Loader.getResultSet(Loader.java:2292) ~[hibernate-core-5.4.12.Final.ja

最新发布

04-03

例如，一个字段是latin1_swedish_ci，另一个是utf8mb4_general_ci，这时候在比较或操作时就会报错。用户提到错误涉及到latin1_swedish_ci和utf8mb4_unicode_ci，这说明他们的数据库中存在不同字符集或排序规则的...

数据库执行sql时Illegal mix of collations (latin1_swedish_ci,IMPLICIT), (utf8mb4_general_ci,COERCIBLE), (ut

qq_21687123的博客

05-26

1793

Illegal mix of collations (latin1_swedish_ci,IMPLICIT), (utf8mb4_general_ci,COERCIBLE), (utf8mb4_general_ci,COERCIBLE) for operation 'replace' 场景：由一个库往另外一个库进行数据的复制时，复制完成后的数据写入修改有问题，查询没问题，具体的报错信息是如上，当然java代码里抛出的错误也是和这个一样的: 首先百度一搜索，就是字符集的问题，执行了sql查看对比了一下，字.

【MySQL】1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIB

Trees__的博客

02-04

3337

1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation ‘=’"

mysql报错：Cause: java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (ut

weixin_42844971的博客

06-24

1956

Cause: java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation ‘like’ ; uncategorized SQLException; SQL state [HY000]; error code [1...

mybatis插入数据报错:Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_c

qq_27312237的博客

01-05

1575

mybatis 插入数据时报的错如下图：（需要navicat 系列的可视化工具） 1、百度出来的解决方法，首先是查询以下两个语句，确保字符集和排序规则正确：（1）字符集：show variables like 'character_set_%'; 正常查出来是这个样子修改语句： set character_set_client=utf8; set character_set_connection=utf8; set character_set_database=utf8; set cha.

Mybatis学习中遇到的错误java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (ut

noaman_wgs的博客

09-27

7649

在Mybatis学习存储过程调用的时候，老是出现【java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='】这个错，百度了下意思是返回的结果有两种字符集。一般这种情况在排除编程语言中单独设置的字符集错误

java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) a

u014164005的博客

11-14

1247

在项目中遇到一个这样的错误，一看知道是字符集的问题。那么去查看数据库 的字符集 mysql > show variables like '%character%'; 可是呢，字符集没问题，再看: mysql > SHOW VARIABLES LIKE 'collation_%'; 还是没问题，这就尴尬了，为什么呢。在网上看了看，有说去查看表的...

1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE)

徊忆羽菲

09-06

587

原因: 因为新创建的表字符集是latin1_swedish_ci，而原有的字符集需要utf8mb4_general_ci，所以报错。

解决"Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)

wujingwen1111的专栏

10-12

6248

原文：http://www.111cn.net/database/mysql/41922.htm 今天在用java与mysql数据库时发现Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COER错误提示，下面我们来看解决方法吧。部署完项目，测试一下，诶，数据出来了没有

【Java】application run failed Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and

wyz0516071128的博客

05-16

364

springboot 启动时报这个错：application run failed Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_COERCIBLE) 查看数据的编码再用 SHOW VARIABLES LIKE ‘collation_%’; 查看一下显示最后依次执行一下命令...