mysql5.7 字符集 utf8mb4 的默认排序规则为 utf8mb4_general_ci
mysql8 字符集 utf8mb4 的默认排序规则为 utf8mb4_0900_ai_ci

mysql5.7 升级为 mysql8 后更改字符集和排序规则方式有以下几种

1. 只修改库字符集和排序规则

1ALTER DATABASE database_name CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;

2. 只更改表字符集和排序规则

1ALTER TABLE table_name CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;

3. 只更改字段字符集和排序规则

1ALTER TABLE table_name CHANGE COLUMN column_name varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '字段备注';
2

4. 同时更改表和改表下所有字段字符集和排序规则

1ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci;
2