MySQL Illegal mix of collations (utf8_tolower_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for oper

一句话的事:


这是个编码问题。

我用的 dbForge Studio for Mysql

MySQL  Illegal mix of collations (utf8_tolower_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for oper

mysql server 版本为 8.0.12


MySQL  Illegal mix of collations (utf8_tolower_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for oper

如上图,在客户端选择相应的编码方式,或者直接勾选“detect mysql charactor set” 即可正常执行。
且dbforge studio for mysql可以调试。