给表格操作按钮配置访问控制时候报错

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’;

改成一样的 可以了