Mariadb Mysql 字符集设置

Character Sets and Collations

Fython 发布

Mariadb Mysql Character Sets and Collations

MariaDB数据库管理系统是MySQL的一个分支,主要由开源社区在维护,采用GPL授权许可。开发这个分支的原因之一是:甲骨文公司收购了MySQL后,有将MySQL闭源的潜在风险,因此社区采用分支的方式来避开这个风险。

所以说mariadb完全兼容mysql的设置,完全可以用mariadb代替mysql

初次安装完mariadb后运行mysql_secure_installation

本人centos7编辑/etc/my.cnf添加如下配置(utf8mb4支持4个字节的emoji表情完全兼容utf8,当然也可以换成utf8不使用表情)

[mysqld] 
init_connect='SET collation_connection = utf8mb4_unicode_ci' 
init_connect='SET NAMES utf8mb4' 
skip-character-set-client-handshake
# 服务端默认字符集
character-set-server=utf8mb4 
# 连接层默认字符集
collation-server=utf8mb4_unicode_ci

[client]
# 客户端来源数据默认字符集
default-character-set=utf8mb4

[mysql]
# 客户端来源数据默认字符集
default-character-set=utf8mb4

重启mariadb服务,运行systemctl restart marriadb.service

登录后show variables like '%char%'show variables like '%collation%'查看是否和如下相同。

MariaDB [(none)]> show global variables like '%char%';
+--------------------------+----------------------------+
| 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/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)

MariaDB [(none)]> show global variables like '%collation%';
+----------------------+--------------------+
| Variable_name        | Value              |
+----------------------+--------------------+
| collation_connection | utf8mb4_unicode_ci |
| collation_database   | utf8mb4_unicode_ci |
| collation_server     | utf8mb4_unicode_ci |
+----------------------+--------------------+
3 rows in set (0.00 sec)
分享

0 评论    Fython's Blog
  • 暂无评论

免登录入口