0.关于UTF-8
UTF-8(8-bit Unicode Transformation Format)是一种针对Unicode的可变长度字符编码,又称万国码。由Ken Thompson于1992年创建。现在已经标准化为RFC 3629。UTF-8用1到6个字节编码Unicode字符。用在网页上可以统一页面显示中文简体繁体及其它语言(如英文,日文,韩文)。
如上所言,修改mysql 字符集为UTF-8的目的,其实是为了使mysql支持中文,mysql默认的字符集是不支持中文的。
1. 查看当前的字符集
SHOW VARIABLES LIKE ‘character%’;
2. 通过vim打开 mysql配置文件
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf
3. 将以下内容添加到配置文件
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8
4.查看结果
SHOW VARIABLES LIKE ‘character%’;
+--------------------------+----------------------------+
| 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/ |
+--------------------------+----------------------------+
如此大功告成
网友评论