记录：数据库字符编码gbk问题

(1267, "Illegal mix of collations (gbk_chinese_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='")

SELECT * FROM searchdicts WHERE word = 'xiao er急诊科'
SELECT * FROM searchdicts WHERE word = '消⼃'
SELECT * FROM searchdicts WHERE word = '陈㬢'

(1267, "Illegal mix of collations (gbk_chinese_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='")

alter table table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

备注：此操作有一定的风险，需要谨慎