如何将整个MySQL数据库字符集和排序规则转换为UTF

使用

ALTER DATAbase

ALTER TABLE

ALTER DATAbase databasename CHARACTER SET utf8mb4 COLLATE utf8mb4_unipre_ci;ALTER TABLE tablename ConVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unipre_ci;

或者，如果您仍在不支持4字节UTF-8的MySQL 5.5.2或更早版本上，请使用

utf8

utf8mb4

ALTER DATAbase databasename CHARACTER SET utf8 COLLATE utf8_unipre_ci;ALTER TABLE tablename ConVERT TO CHARACTER SET utf8 COLLATE utf8_unipre_ci;