mysql设置字符集CHARACTER SET-白红宇

mysql设置字符集CHARACTER SET

阅读量：6609 次

发布时间：2019-06-24

本文共 2585 字，大约阅读时间需要 8 分钟。

在 my.cnf 配置文件中设置相关选项，改变为相应的character set。

设置数据库编码(sudo vi /etc/mysql/my.cnf)：

[client]default-character-set = utf8[mysqld]character-set-server = utf8collation-server = utf8_general_ci

查看设置结果

更改my.cnf之前：

mysql> SHOW VARIABLES LIKE '%char%';+--------------------------+---------------------------------------------------------------+| Variable_name            | Value                                                         |+--------------------------+---------------------------------------------------------------+| character_set_client     | utf8                                                          || character_set_connection | utf8                                                          || character_set_database   | latin1                                                        || character_set_filesystem | binary                                                        || character_set_results    | utf8                                                          || character_set_server     | latin1                                                        || character_set_system     | utf8                                                          || character_sets_dir       | /usr/local/mysql-5.6.21-linux-glibc2.5-x86_64/share/charsets/ |+--------------------------+---------------------------------------------------------------+

设置之后，重启mysql服务($ sudo service mysql restart)：

mysql> SHOW VARIABLES LIKE '%char%';+--------------------------+---------------------------------------------------------------+| 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/local/mysql-5.6.21-linux-glibc2.5-x86_64/share/charsets/ |+--------------------------+---------------------------------------------------------------+

转载于:https://www.cnblogs.com/shaojiafeng/p/9791211.html

你可能感兴趣的文章

Spring Cloud云架构 - SSO单点登录之OAuth2.0 登出流程(3)

查看>>

软件开发各阶段交付物列表

查看>>