MySQL8.0默认字符集编码utf8mb4
使用以下命令查看默认字符集编码(在MySQL下使用)
show variables like ‘%character%’;
±-------------------------±-------------------------------+
| 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 | utf8mb3 |
| character_sets_dir | /usr/share/mysql-8.0/charsets/ |
±-------------------------±-------------------------------+
MySQL8.0建立数据库,字符集默认,向表中插入中文数据后
没有问题。查看表默认字符集是utf8mb4
mysql> show create table dbtable1;
±---------±------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
±---------±------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| dbtable1 | CREATE TABLE dbtable1
(
id
int NOT NULL AUTO_INCREMENT,
username
varchar(20) NOT NULL,
password
varchar(20) DEFAULT NULL,
name
varchar(20) DEFAULT NULL,
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
±---------±------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> select * from dbtable1;
±—±---------±---------±-------+
| id | username | password | name |
±—±---------±---------±-------+
| 1 | 123 | 123 | 张三 |
±—±---------±---------±-------+
1 row in set (0.00 sec)
MySQL5.7默认字符集编码latin1,所以导致乱码
修改默认字符集编码,在家目录下使用命令
vim /etc/my.cnf
进入MySQL配置文件
按i进入编辑模式
在配置文件中添加配置
character_set_server=utf8
esc退出编辑模式
:wq保存退出
改完配置文件后需要重启MySQL服务
systemctl restart mysqld