错误代码:1267 排序规则 (utf8_general_ci,IMPLICIT) 和 (latin1_swedish_ci,NUMERIC) 的非法混合用于操作 '=' 简单选择查询错误 [英] Error Code: 1267 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,NUMERIC) for operation '=' error on simple select query

问题描述

我得到了

#1267 - 操作 '='

#1267 - Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,NUMERIC) for operation '='

以下查询出现此错误

SELECT * FROM 
sm_product_inventories_list 
WHERE  inventory_date =  CURDATE() 
AND  inventory_time =  CURTIME()

我试图通过

ALTER TABLE sm_product_inventories_list CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci

我仍然遇到错误.inventory_date 的类型是 date，inventory_time 的类型是 varchar

still I am getting error. Type of inventory_date is date and inventory_time is varchar

提前致谢.

推荐答案

一个快速的解决方案是在比较之前添加binary"，如下所示，

A quick solution is to add "binary" before comparing as follows,

WHERE binaryinventory_date = binary CURDATE() AND binary inventory_time = binary CURTIME()

这篇关于错误代码:1267 排序规则 (utf8_general_ci,IMPLICIT) 和 (latin1_swedish_ci,NUMERIC) 的非法混合用于操作 '=' 简单选择查询错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！