Typecho博客支持emoji表情设置(采用utf8mb4编码)

Mr.He
2021-04-03 / 0 评论 / 24 阅读 / 正在检测是否收录...
一,修改数据库配置文件config.inc.php

网站根目录中,有一个config.inc.php的文件
找到

'charset' => 'utf8',

修改成

'charset' => 'utf8mb4', 
二,进入phpMyAdmin管理

ebc2d20154472cba

直接运行以下sql语句

alter table typecho_comments convert to character set utf8mb4 collate utf8mb4_general_ci;
alter table typecho_contents convert to character set utf8mb4 collate utf8mb4_general_ci;
alter table typecho_fields convert to character set utf8mb4 collate utf8mb4_general_ci;
alter table typecho_metas convert to character set utf8mb4 collate utf8mb4_general_ci;
alter table typecho_options convert to character set utf8mb4 collate utf8mb4_general_ci;
alter table typecho_relationships convert to character set utf8mb4 collate utf8mb4_general_ci;
alter table typecho_users convert to character set utf8mb4 collate utf8mb4_general_ci;
0

评论 (0)

取消