Typecho添加emoji表情

云计算小黑

发布于 2022-12-28 20:42:21

6020

1、修改数据库编码在PhpMyadmin中选择typecho数据库，操作-->排序规则-->选择utf8mb4_unicode_ci然后执行。或者在服务器中执行（通用版）首先在服务器中执行

    mysql -uroot -p

输入数据库密码，之后执行

use 数据库名;

最后执行以下命令：

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

2、在config.inc.php修改