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

最新推荐文章于 2024-07-22 15:35:00 发布
原创 最新推荐文章于 2024-07-22 15:35:00 发布 · 2k 阅读 · 1 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

博客指出Java中出现SQLException，提示字符集(latin1_swedish_ci,IMPLICIT)和(utf8_general_ci,COERCIBLE)在‘like’操作中不兼容。原因是表格字符集为latin1_swedish_ci，应改成utf_8。

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 [1267]; Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation ‘like’; nested exception is java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation ‘like’

原因：此表格的字符集是latin1_swedish_ci 应该改成utf_8

Caused by: java.sql.SQLException: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_cro
知识改变命运，ヾ(◍°∇°◍)ﾉﾞ【求关注】
10-15 2328
最近发布新环境时，运行APP报错
如何解决Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (gbk_chinese_ci,IMPLICIT)的问题
逍遥友的专栏
10-28 5286
在执行以下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 4146
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 705
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 (utf8mb4_general_c
nicedaych的博客
05-14 5552
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">
Mybatis学习中遇到的错误java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (ut
noaman_wgs的博客
09-27 7705
在Mybatis学习存储过程调用的时候，老是出现【java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='】这个错，百度了下意思是返回的结果有两种字符集。一般这种情况在排除编程语言中单独设置的字符集错误
系统报错解决：Illegal mix of collations (gbk_chinese_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)
ACGkaka的博客
12-28 2842
### Cause: java.sql.SQLException: Illegal mix of collations (gbk_chinese_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation ‘like’ 原因分析： 1.数据库表数据的编码不一致； 解决： 用sql将数据修改为统一编码： alter table lf_ctrl_net convert to character set utf8 collate utf8_genera
SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (gb231...
weixin_30301449的博客
08-04 5539
SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (gb2312_chinese_ci,COERCIBLE) for operation '=' 在操作MySQL数据库时，报“ error code [12...
2025-04-01 17:14:59.657 ERROR 6652 --- [nio-5000-exec-5] o.h.engine.jdbc.spi.SqlExceptionHelper : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' 2025-04-01 17:14:59.682 ERROR 6652 --- [nio-5000-exec-5] 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 (utf8_general_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.jar:5.4.12.Final] at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2050) ~[hibernate-core-5.4.12.Final.jar:5.4.12.Final] at or
04-02
嗯，用户遇到了Hibernate和MySQL之间的字符集问题，导致出现Illegal mix of collations错误。我需要仔细分析这个问题，并给出解决方案。首先，根据用户提供的引用资料，错误通常是由于不同字符集或校对规则的混合...
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语句报错：java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_g
浮生未歇的博客
05-09 1549
错误截图 发生错误的原因：sql语句中有中文条件，查询的表中，表的编码不一致，导致出现这个错误 解决方案： 先查看所有表的结构与编码是否一致：show full columns from zx_log_manage 修改表现在的编码 ALTER TABLE `表名`convert to character set utf8mb4; utf8mb4:是你要设置的编码，我这里是utfmb4 ...
mysql错误:Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)
xocom的专栏
06-27 668
-- ALTER DATABASE test CHARACTER SET utf8 COLLATE utf8_general_ci -- ALTER TABLE zwxsougoupost CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci set @@character_set_server='utf8';
java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) a
u014164005的博客
11-14 1274
  在项目中遇到一个这样的错误，一看知道是字符集的问题。 那么去查看数据库 的字符集 mysql &gt; show variables like '%character%'; 可是呢，字符集没问题，再看:   mysql &gt; SHOW VARIABLES LIKE 'collation_%';  还是没问题，这就尴尬了，为什么呢。   在网上看了看，有说去查看表的...
[Err] 1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)
aongyd的专栏
07-14 1455
[Err] 1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='  在查询mysql数据库的时候遇到这个问题，要想查询成功，可以在运行查询语句前，先运行set names 'latin1'. 如： set names 'la
解决 Mysql Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)
lzzyok的专栏
07-06 4520
mysql根据中文条件查询时，报如标题的异常，其本质是：数据库出现了两种字符集。 SHOW VARIABLES LIKE 'character_set_%'; +--------------------------+----------------------------+ | Variable_name | Value | +--------------------------+----------------------------+ | character_set_client |.
解决 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)
dqchouyang的专栏
02-27 6565
OperationalError: (1267, "Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'") 今天在系统里做了一个中文的检索，结果 就出现如上的错误提示，第一反应是数据库字符集的问题，那么就按照下面的步骤，一步一步来排查...
java.sql.SQLException: Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_0900_ai_
BaynotBar的博客
07-22 830
### Cause: java.sql.SQLException: Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '='] with root cause java.sql.SQLException: Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_0900_
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation
yhyhyh_的博客
06-12 707
用show full columns from tablename 该语句查询下这个表的每个字段的编码，才发现这个表中 其中一个字段的编码是latin1_swedish_ci（这个字段是建表后手动加的），执行了下alter table tablename convert to character set utf8，把该表的所有字段 都设置成utf-8了，问题就解决了。这个错误，就是查询的sql编码 与 数据库 中的 表字段编码不一致导致的，改成一致就行了。这里要说的是，本人排查的时候发现的问题。
mysql查询报错了：Cause: java.sql.SQLException: Illegal mix of collations (utf8mb4_bin,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
09-30
具体来说，你在比较两个字符集不兼容的字段时出现了问题，一个是utf8mb4_bin，另一个是utf8_general_ci。 要解决这个问题，有几种方法可以尝试： 1. 修改比较操作的字符集为相同的：你可以在查询语句中使用COLLATE...
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值