让 Typecho 支持 Emoji 表情

May 27, 2018

1366views

1197字数

<h2>前言</h2><p>嘿嘿嘿，最近没文章可写啦，只能水水水！</p><h2>正文</h2><p>首先修改数据库编码啦</p><h3>1. 修改数据库编码</h3><p>进入 PhpMyadmin，在博客数据所在数据库的设置（操作 - 排序规则）中，选择 <strong>utf8mb4_unicode_ci</strong></p><h3>2. 修改数据库表编码</h3><p>执行以下 sql 语句</p><pre><code class="lang-sql">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;</code></pre><p>数据库表名中的 typecho <strong>自行修改为数据库表前缀</strong></p><h3>3. 修改数据库配置文件</h3><p>修改网站根目录数据库配置文件 (config.inc.php) 中，大约第五行<code>'charset' =&gt; 'utf8',</code>中的<code>utf8</code> 改为<code>utf8mb4</code></p><pre><code class="lang-sql">$db-&gt;addServer(array ( 
'host' =&gt; localhost, 
'user' =&gt; 'youruser', 
'password' =&gt; 'yourpassword', 
'charset' =&gt; 'utf8mb4', //修改这一行
'port' =&gt; 3306,
'database' =&gt; 'yourdatabase' ), Typecho_Db::READ | Typecho_Db::WRITE);</code></pre><p>然后就可以装疯啦！</p><hr class="content-copyright" style="margin-top:50px" /><blockquote class="content-copyright" style="font-style:normal"><p class="content-copyright">版权属于：XSY</p><p class="content-copyright">本文链接：<a class="content-copyright" href="https://www.xsy.fun/archives/70/">https://www.xsy.fun/archives/70/</a></p><p class="content-copyright">转载时须注明出处及本声明</p></blockquote>

Last modification：April 4th, 2019 at 10:32 pm

If you think my article is useful to you, please feel free to appreciate

让 Typecho 支持 Emoji 表情