数据库字符集

查询语句

show variables like "%char%"

查询结果

1. 腾讯云phpmyadmin

Variable_name	Value
character_set_client	utf8mb4
character_set_connection	utf8mb4
character_set_database	utf8
character_set_filesystem	binary
character_set_results	utf8mb4
character_set_server	latin1
character_set_system	utf8
character_sets_dir	/usr/share/mysql/charsets/
validate_password_special_char_count	1

2. 本地MySQL-Front

Variable_name	Value
character_set_client	utf8mb4
character_set_connection	utf8mb4
character_set_database	utf8
character_set_filesystem	binary
character_set_results	utf8mb4
character_set_server	utf8
character_set_system	utf8
character_sets_dir	G:\php\phpstudy_pro\Extensions\MySQL5.7.26\share\charsets\

比对结果

只有 character_set_server 一个是 latin1， 一个是 utf8。