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

最新推荐文章于 2024-10-30 17:56:13 发布

nicedaych

最新推荐文章于 2024-10-30 17:56:13 发布

阅读量5.4k

点赞数 3

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

本文链接：https://blog.csdn.net/nicedaych/article/details/106128093

版权

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

摘要由CSDN通过智能技术生成

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

分享到新浪微博

扫一扫

专栏目录

Caused by: java.sql.SQLException: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_cro

知识改变命运，ヾ(◍°∇°◍)ﾉﾞ【求关注】

10-15

1971

最近发布新环境时，运行APP报错

【FAQ】Illegal mix of collations (utf8mb4_general_ci,COERCIBLE) and (utf8mb4_0900_ai_ci,COERCIBLE)

loongshawn的博客

10-15

2114

ror querying database. Cause: java.sql.SQLException: Illegal mix of collations (utf8mb4_general_ci,COERCIBLE) and (utf8mb4_0900_ai_ci,COERCIBLE) for operation ‘<>’ show global variables like ‘%coll%’, set global default_collation_for_utf8mb4 = ‘utf

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

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

逍遥友的专栏

10-28

5205

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

mysql 8.0.39 Caused by: java.sql.SQLException: Illegal mix of collations 异常解决

最新发布

LFCuiYs的博客

10-30

486

发现设置utf8mb3_general_ci 会报错，所以要与参数一直改成utf8mb4_general_ci 即可生效。java服务可以正常启动，页面发现查询报错Illegal mix of collations。经查看发现是关联表排序异常，因是mysql 8.0.39。然后定位异常调成一直参数问题解决。

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

weixin_43564627的博客

07-04

4034

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

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

weixin_30906425的博客

06-23

632

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

1472

错误截图发生错误的原因：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

986

报错太长，题目容不下： 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

5441

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】1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIB

Trees__的博客

02-04

3246

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

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

qq_21687123的博客

05-26

1714

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

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

weixin_42844971的博客

06-24

1915

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

1492

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

7625

在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

1235

在项目中遇到一个这样的错误，一看知道是字符集的问题。那么去查看数据库 的字符集 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

417

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

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

wujingwen1111的专栏

10-12

6168

原文：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

344

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

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

CarloPan的博客

10-10

2074

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...

Caused by: java.sql.SQLException: Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8m

01-08

根据提供的引用内容，您遇到了一个错误：`java.sql.SQLException: Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '='`。这个错误通常是由于数据库中的...