查询所有跟字符集相关的信息 show variables like ‘%char%’; 查看字符集对应的校对规则 show collation where charset = ‘utf8mb4’; #更改数据库编码: ALTER DATABASE caitu99 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; #更改表的编码: ALTER DATABASE caitu99 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;