非法的排序规则混合MySQL错误 [英] Illegal mix of collations MySQL Error

问题描述

在处理大量数据时出现了这个奇怪的错误...

I'm getting this strange error while processing a large number of data...

Error Number: 1267

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

SELECT COUNT(*) as num from keywords WHERE campaignId='12' AND LCASE(keyword)='hello again æ˜" ã‹ã‚‰ ã‚ã‚‹ å ´æ‰€'

我该怎么做才能解决此问题?我可以以某种方式转义该字符串，这样就不会发生此错误，还是需要以某种方式更改我的表编码，如果是，应该将其更改为什么?

What can I do to resolve this? Can I escape the string somehow so this error wouldn't occur, or do I need to change my table encoding somehow, and if so, what should I change it to?

推荐答案

SET collation_connection = 'utf8_general_ci';

然后访问您的数据库

ALTER DATABASE your_database_name CHARACTER SET utf8 COLLATE utf8_general_ci;

ALTER TABLE your_table_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

MySQL有时会毫无道理地潜入瑞典语.

MySQL sneaks swedish in there sometimes for no sensible reason.

这篇关于非法的排序规则混合MySQL错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！