MySQL illegal mix of collations (gbk_chinese_ci, implicit) and (gb2312_chinese_ci, implicit) for opera

When an in statement is added to the SQL statement, the illegal mix of collations (gbk_chinese_ci, implicit) and (gb2312_chinese_ci, implicit) for Operation '=' error is returned.

In the prompt, the character set is incorrect.

First, I changed the character set of the database. The error still persists.

Then, the character set of the table is changed to solve the problem. The modification method is to modify the character set in "design" of navicat. For example, the red part.