操作'='的排序规则(utf8mb4_unicode_ci，IMPLICIT)和(utf8mb4_general_ci，IMPLICIT)的非法混合

问题描述

限时删除！！

我收到此错误；

我将排序规则"更改为"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)的非法混合的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！

1403页，肝出来的..