[Typecho]添加emoji表情

7月前 / Typecho / 33浏览

[Typecho]添加emoji表情

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修改

    'charset'   =>  'utf8mb4',

typecho