SHOW VARIABLES LIKE 'coll%';
执行下面语句
SELECT *
FROM
threat_event
WHERE expirationTime<0
AND '2012-11-09 09:23:05' > ADDTIME(startTime, '30')
出错:
SQL 错误 写道
Query : SELECT * FROM utmp.threat_event WHERE expirationTime<0 AND '2012-11-09 09:23:05' > ADDTIME(startTime, '30...
Error Code : 1267
Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,NUMERIC) for operation '>'
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000
Error Code : 1267
Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,NUMERIC) for operation '>'
Execution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000
使用错误中写的编码方式:latin1_swedish_ci
执行:
SET collation_connection = 'latin1_swedish_ci';
再次执行
SHOW VARIABLES LIKE 'coll%';
查看结果为:
其中collation_connection变为:latin1_swedish_ci
再次执行报错的SQL语句,执行成功