Illegal mix of collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation ‘=’
数据库是
mysql
nocobase 版本是 v1.6.17
检查下mysql 数据库排序规则、各个数据表的排序规则,是否存在utf8mb4_0900_ai_ci utf8mb4_general_ci两种及以上情况
是有两个排序。我没动过奇怪了
SELECT CONCAT(‘ALTER TABLE ', TABLE_SCHEMA, '
.', TABLE_NAME, '
CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;’) AS sql_command
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ‘nocobase’
AND TABLE_TYPE = ‘BASE TABLE’;
改成一样的 可以了