操作'='的排序规则(utf8mb4_unicode_ci，IMPLICIT)和(utf8mb4_general_ci，IMPLICIT)的非法混合 [英] Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='

问题描述

我收到此错误；

操作'='的归类(utf8mb4_unicode_ci，IMPLICIT)和(utf8mb4_general_ci，IMPLICIT)的非法混合

Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='

我将排序规则"更改为"utf8mb4_unicode_ci".然后表被截断，我再次重新导入行.但是仍然出现相同的错误

I changed "Collations" to "utf8mb4_unicode_ci". Then tables were truncated and I re-import rows again. But still getting same error

推荐答案

我猜您在要连接的表上有不同的排序规则.它表示您在操作=中使用了非法的排序规则混合.

I am guessing you have different collations on the tables you are joining. It says you are using an illegal mix of collations in operations =.

因此，您需要设置排序规则. 例如:

So you need to set collation. For example:

WHERE tableA.field COLLATE utf8mb4_general_ci = tableB.field

然后，您在=操作上设置了相同的排序规则.

Then you have set the same collations on the = operation.

由于您没有提供有关表的更多信息，因此这是我可以提供的最佳伪代码.

Since you have not provided more info about the tables this is the best pseudo code I can provide.

这篇关于操作'='的排序规则(utf8mb4_unicode_ci，IMPLICIT)和(utf8mb4_general_ci，IMPLICIT)的非法混合的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！