MySQL Illegal mix of collations for operation 'like' 解决方案
程序员文章站
2022-06-03 09:45:45
...
MySQL Illegal mix of collations for operation 'like'
在 MySQL 5.5 以上, 若字段类型 Type 是 time,date,datetime
在 select时如果使用 like ‘%中文%’ 会出现 Illegal mix of collations for operation 'like'
在编程时要对每个字段进行查找,
在执行时可能就会出现时间字段 like '%中文%'
这种语法,
在旧版的 MySQL 是不会出现错误的.
升到 MySQL 5.5 以上, 必需改成 like binary '%中文%'
即可避免出现错误.
上一篇: 常见数据库 URL
下一篇: hash #怎么去掉
推荐阅读
-
解决 Mysql Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)
-
对mysql Illegal mix of collations(gbk_chinese_ci,IMPLICIT) a_MySQL
-
MySQL查询:Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) fo
-
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (_MySQL
-
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (_MySQL
-
MySQL Illegal mix of collations for operation 'like' 解决方案
-
mysql 保存数据出现 Illegal mix of collations (gbk_chinese_ci
-
解决 Mysql Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)
-
mysql Illegal mix of collations error
-
mysql Illegal mix of collations error