[转载]linux下配置mariadb支持中文

最新推荐文章于 2024-09-25 19:36:10 发布

转载最新推荐文章于 2024-09-25 19:36:10 发布 · 241 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/zzyyxxjc/p/4402080.html

文章标签：

#数据库

本文介绍如何在MySQL 5.5中通过配置my.cnf文件来设置服务器和客户端的字符集为UTF-8，并确保连接时使用utf8_unicode_ci校对集。展示了具体的配置项及验证配置是否生效的方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

转载网址:http://www.cnblogs.com/vingi/articles/4302330.html

修改/etc/mysql/my.cnf
On MySQL 5.5 I have in my.cnf

[mysqld] 
init_connect='SET collation_connection = utf8_unicode_ci' 
init_connect='SET NAMES utf8' 
character-set-server=utf8 
collation-server=utf8_unicode_ci 
skip-character-set-client-handshake

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8

Result is

mysql> show variables like "%character%";show variables like "%collation%";

+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)

+----------------------+-----------------+
| Variable_name        | Value           |
+----------------------+-----------------+
| collation_connection | utf8_unicode_ci |
| collation_database   | utf8_unicode_ci |
| collation_server     | utf8_unicode_ci |
+----------------------+-----------------+
3 rows in set (0.00 sec)