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

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

其他数据库开发 > MySQL

收藏回复

[问题点数：100分，结帖人am2000]

⋅BI板块为什么设在SQL SERVER栏目中 ⋅如何获取字符串中的值 ⋅出现java.sql.SQLException: Io 异常: Connection reset by peer: socket write error 更多帖子 关注私信空间博客 am2000 等级 本版专家分：340 结帖率 100%: HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.login_jsp._jspService(login_jsp.java:417)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2901)
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1584)
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1675)
com.mysql.jdbc.Connection.execSQL(Connection.java:2295)
com.mysql.jdbc.Connection.execSQL(Connection.java:2228)
com.mysql.jdbc.Statement.executeQuery(Statement.java:1159)
bookshop.run.login.excute(login.java:66)
org.apache.jsp.login_jsp._jspService(login_jsp.java:71)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.

--------------------------------------------------------------------------------

Apache Tomcat/5.0.28

2005-07-20 16:49:44

点赞只看楼主引用举报楼主收起

展开阅读全文

⋅substring中的汉字问题 ⋅急！用vb如何处理多个socket连接？ ⋅多表update问题，在线等。 更多帖子 关注私信空间博客 mathematician 等级 本版专家分：18261 勋章 黄花 2005年1月其他数据库开发大版内专家分月排行榜第二 蓝花 2005年7月其他数据库开发大版内专家分月排行榜第三 2005年6月其他数据库开发大版内专家分月排行榜第三 2004年12月其他数据库开发大版内专家分月排行榜第三: 错误是在你的结果集中有两种字符集。
比如说你在两个表联合查询，一个表的字符集是latin1，另一个是utf8，这样在你的结果集中有两种字符集，mysql会报上面的错误。
一个表中不同的字段使用不同的字符集，也是一个道理。
用SHOW CREATE TABLE table_name;可以看出具体的字符集设置。

解决方法：
将不同的字符集，转化成统一的字符集。

2005-07-20 17:48:27

点赞只看TA 引用举报 #1得分 80

⋅BI板块为什么设在SQL SERVER栏目中 ⋅如何获取字符串中的值 ⋅出现java.sql.SQLException: Io 异常: Connection reset by peer: socket write error 更多帖子 关注私信空间博客 am2000 等级 本版专家分：340: 是的。我查了帮助手册，说是user的字符集没有设,默认为utf8,我如何将其转为latin1.

2005-07-21 12:40:51

点赞只看TA 引用举报 #2得分 0

⋅BI板块为什么设在SQL SERVER栏目中 ⋅如何获取字符串中的值 ⋅出现java.sql.SQLException: Io 异常: Connection reset by peer: socket write error 更多帖子 关注私信空间博客 am2000 等级 本版专家分：340: After an upgrade to MySQL 4.1, the statement fails:

mysql> SELECT SUBSTRING_INDEX(USER(),'@',1);
ERROR 1267 (HY000): Illegal mix of collations
(utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE)
for operation 'substr_index'

The reason this occurs is that usernames are stored using UTF8 (see section 11.6 UTF8 for Metadata). As a result, the USER() function and the literal string '@' have different character sets (and thus different collations):

mysql> SELECT COLLATION(USER()), COLLATION('@');
+-------------------+-------------------+
| COLLATION(USER()) | COLLATION('@')    |
+-------------------+-------------------+
| utf8_general_ci   | latin1_swedish_ci |
+-------------------+-------------------+

One way to deal with this is to tell MySQL to interpret the literal string as utf8:

mysql> SELECT SUBSTRING_INDEX(USER(),_utf8'@',1);
+------------------------------------+
| SUBSTRING_INDEX(USER(),_utf8'@',1) |
+------------------------------------+
| root                               |
+------------------------------------+

Another way is to change the connection character set and collation to utf8. You can do that with SET NAMES 'utf8' or by setting the character_set_connection and collation_connection system variables directly.

2005-07-21 12:53:10

点赞只看TA 引用举报 #3得分 0

⋅substring中的汉字问题 ⋅急！用vb如何处理多个socket连接？ ⋅多表update问题，在线等。 更多帖子 关注私信空间博客 mathematician 等级 本版专家分：18261 勋章 黄花 2005年1月其他数据库开发大版内专家分月排行榜第二 蓝花 2005年7月其他数据库开发大版内专家分月排行榜第三 2005年6月其他数据库开发大版内专家分月排行榜第三 2004年12月其他数据库开发大版内专家分月排行榜第三: 表的编码转换可以用（MySQL Version > 4.12）
ALTER TABLE tbl_name CONVERT TO CHARACTER SET charset_name;

之前的版本可以用：
ALTER TABLE tbl_name CHARACTER SET charset_name;

2005-07-21 13:05:59

点赞只看TA 引用举报 #4得分 20

⋅BI板块为什么设在SQL SERVER栏目中 ⋅如何获取字符串中的值 ⋅出现java.sql.SQLException: Io 异常: Connection reset by peer: socket write error 更多帖子 关注私信空间博客 am2000 等级 本版专家分：340: 我不是要转换表的字符集，我是想把用户的字符集设置为latin1;

2005-07-21 14:56:29

点赞只看TA 引用举报 #5得分 0

收起

收藏回复

am2000

等级：

关注私信 TA的帖子

错误：1267, "Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE): 项目在执行迁移，生成库表后，出现错误：(1267, "Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='") 造成该错误的原因是由于新生成的表的字符集是...

zabbix 报错[Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)...: 新装的zabbix，导入模板或者新建...–Error in query [SELECT usrgrpid,name FROM usrgrp WHERE name='运维组' LIMIT 1] [Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE...

解决 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE): 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 (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,C: java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation ‘=’，意思是说字符编码不一样，不能进行比较，也就是说数据库内部的编码都不...

解决"Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE): 今天在用java与mysql数据库时发现Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COER错误提示，下面我们来看解决方法吧。部署完项目，测试一下，诶，数据出来了没有

[Err] 1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE): [Err] 1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' 在查询mysql数据库的时候遇到这个问题，要想查询成功，可以在运行查询语句前，先运行...

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation: sql查询中文用 '=' 出现Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' 解决办法：在对应的库，选择那张表执行ALTER TABLE 你的表 CONVERT TO ...

mysql错误:Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE): 为什么80%的码农都做不了架构师？>>> ...

Illegal table mix of collation(latin1_swedish_ci,IMPLICIT)and(utf8mb4_general_ci,CORECIBLE)for prera: Unhandled Exception: MySql.Data.MySqlClient.MySqlException: Illegaltable mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '=' 原因是编码格式不统一造成...

Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,NUMERIC) for operation ': 错误描述:Cause: java.sql.SQLException: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,NUMERIC) for operation '<=' 简单来看就是操作的左边和右边的字符集不同，看了...

Mysql: (1267, "Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBL: (1267, "Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='") 这个问题是什么？？ 34 down vote accepted It is helpful to ...

MySQL Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for ...: MySQL Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'UNION' 错误解决方法

Mybatis学习中遇到的错误java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT)...: 在Mybatis学习存储过程调用的时候，老是出现【java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='】这个错，百度了下意思是返回的...

解决Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COER: 今天在用java与mysql数据库时发现Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COER错误提示，下面我们来看解决方法吧。部署完项目，测试一下，诶，数据出来了没有多大问题（暗...

mysql中文异常，Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) ...: 今天在操作mysql的时候，输入中文的时候出现异常，Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' 。上网查了下原因是因为表的字符集不一致。 SHOW ...

解决Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (gbk_chinese_ci,COERCIBLE) for ...: 进入MySQL，分别查看rejectprj...，查看其Collation,如下图其中reviewprj的fhbh为gbk_chinese_ci，而rejectprj的fhbh为latin1_swedish_ci，所以当两表通过fhbh关联时，就会出现以上错误。则通过以下命令将rejectpr...

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COER) 解决办法: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COER) 这是由于mysql 默认的编码格式与存入的数据格式不一样导致的，解决办法：打开mysql安装目录，里面有个my.ini文件，打开这个...

解决Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci错误: 1.SHOW VARIABLES LIKE 'character_set_%'; 查看一下显示+--------------------------+----------------------------+| Variable_name | Value |+--------------------------+---------------...

1267 Illegal mix of collations (gbk_chinese_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) fo: Illegal mix of collations (gbk_chinese_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like' 对于常见的乱码问题，有的在数据库本身已经为gbk或gb2312时候，但是查询出来却是乱码，这是因为...

Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,COERCIBLE)解决: 1、修改my.cnf [root@localhost etc]# vi my.cnf 在[client]下添加 default-charater-set=utf8 在[mysqld]下添加 character_set_server = utf8 2、保存退出后重启mysql就完成了设置编码。 root...

MySql (1267, "Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE): 服务器和客户端的编码方式不一致。...输出信息mysql Ver 14.14 Distrib 5.7.17, for macos10.12 (x86_64) using EditLine wrapper Connection id: 129 Current database: flightdb Current user:

java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_c: java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation ‘=’ 在使用mybatis向数据库中插入数据时报此错误信息，通过报错信息可以看到...

mysql报错：Cause: java.sql.SQLException: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and ...: 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 ...

mysql错误提示Illegal mix of collations (gbk_chinese_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)的一...: mysql 中关于：Error Code: 1267 Illegal mix of collations (gbk_chinese_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) 最近使用mysql遇到了一个问题，当创建一个视图时，出现了如下提示： Error Code: ...

相关热词 c#绘制图形时界面闪烁 c# emgucv 行人 c# datable合并 c# if折叠 c# 设置全局锁 c# 如何定义全局变量 c# 获取剪切板内容 c#推箱子重新开始 c# 读取接口数据 c#配置 mysql