1、只要修改一下表的字符集，如下：

ALTER TABLE users CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

• 1

2、

將比較等式一邊進行字符串轉換，如改為“CONVERT(b.fullCode USING utf8) COLLATE utf8_unicode_ci”


https://blog.csdn.net/eddy23513/article/details/80746140?utm_source=blogxgwz1