mysql存储emoji表情，utf8mb4

来源：互联网发布：qq邮箱有没有mac版本编辑：程序博客网时间：2024/05/16 18:58

首先更改mysql的数据编码，修改mysql的配置文件： /etc/mysql/my.cnf 添加：

<ol class="linenums" style="margin: 0px; padding: 0px 0px 0px 27px; font-family: 'Microsoft YaHei'; list-style: none; line-height: 16px; white-space: pre;"><li class="L7" style="margin: 0px; padding: 0px; font-family: inherit; list-style: decimal; background-image: initial; background-attachment: initial; background-color: rgb(17, 17, 17); background-size: initial; background-origin: initial; background-clip: initial; background-position: initial; background-repeat: initial;"><span style="color:#ff0000;"><span class="pln">character</span><span class="pun">-</span><span class="kwd">set</span><span class="pun">-</span><span class="pln">client</span><span class="pun">-</span><span class="pln">handshake </span><span class="pun">=</span><span class="pln"> FALSE  </span></span></li><li class="L8" style="margin: 0px; padding: 0px; font-family: inherit; list-style: decimal;"><span style="color:#ff0000;"><span class="pln">character</span><span class="pun">-</span><span class="kwd">set</span><span class="pun">-</span><span class="pln">server </span><span class="pun">=</span><span class="pln"> utf8mb4  </span></span></li><li class="L9" style="margin: 0px; padding: 0px; font-family: inherit; list-style: decimal; background-image: initial; background-attachment: initial; background-color: rgb(17, 17, 17); background-size: initial; background-origin: initial; background-clip: initial; background-position: initial; background-repeat: initial;"><span style="color:#ff0000;"><span class="pln">collation</span><span class="pun">-</span><span class="pln">server </span><span class="pun">=</span><span class="pln"> utf8mb4_unicode_ci  </span></span></li><li class="L0" style="margin: 0px; padding: 0px; font-family: inherit; list-style: decimal;"><span style="color:#ff0000;"><span class="pln">init_connect</span><span class="pun">=</span><span class="str">'SET NAMES utf8mb4'</span></span></li></ol>

然后重启，mysql，查看mysql的编码

SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';

+--------------------------+----------------------------+| Variable_name            | Value                      |+--------------------------+----------------------------+| character_set_client     | utf8mb4                    || character_set_connection | utf8mb4                    || character_set_database   | utf8mb4                    || character_set_filesystem | binary                     || character_set_results    | utf8mb4                    || character_set_server     | utf8mb4                    || character_set_system     | utf8                       || character_sets_dir       | /usr/share/mysql/charsets/ || collation_connection     | utf8mb4_unicode_ci         || collation_database       | utf8mb4_unicode_ci         || collation_server         | utf8mb4_unicode_ci         |+--------------------------+----------------------------+

OK,mysql改完了，然后创建数据库：

create database xxx CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

注意mysql 的客户端也得升级到5.5以后。

0 0