1.修改数据库的编码 utf8mb4
ALTER DATABASE fecpx CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER DATABASE fecpx DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
2.修改边的编码为 utf8mb4
ALTER TABLE fecpx_addons CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
3.数据库所有表的编码批量修改
SELECT
CONCAT(
'ALTER TABLE ',
TABLE_NAME,
' CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;'
)
FROM
information_schema.`TABLES`
WHERE
TABLE_SCHEMA = '数据库名称'; // 将文字替换为数据库名称
执行后会生成很多的sql语句,譬如:
ALTER TABLE `fecpx_addons_language_product_collection` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE `fecpx_addons_language_product_options_unique` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE `fecpx_addons_notice_email_theme` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
粘贴到mysql中执行即可