关联查询报错

  

错误代码： 1267 Illegal mix of collations (utf8mb4_general_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT)

两个字段的排序编码方式不同导致的

ALTER TABLE soft_contract_info  CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE soft_apply_info   CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE soft_project_info   CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;