一、Illegal mix of collations (utf8mb4_general_ci,COERCIBLE) and (utf8mb4_0900_ai_ci,COERCIBLE) for operation ‘=’ MySql字符串比较排序规则报错 二、解决方法:在字符串后定义当前排序规则 SELECT * FROM bis_goods_infor WHERE f_code(create_by)="xgh" COLLATE utf8mb4_general_ci