同一个 MySQL ,my.cnf 中配置了
[mysqld]
character-set-server=utf8
collation-server=utf8_general_ci
执行以下 SQL
show variables like '%char%';
show variables like 'collation%';
MySQL cli 查询结果
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/ |
Variable_name | Value |
---|---|
collation_connection | utf8_general_ci |
collation_database | utf8_general_ci |
collation_server | utf8_general_ci |
navicat 、navicat 命令行、datagrip 结果
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 | /usr/local/mysql/share/charsets/ |
Variable_name | Value |
---|---|
collation_connection | utf8mb4_general_ci |
collation_database | utf8_general_ci |
collation_server | utf8_general_ci |
为何结果不同
这是一个专为移动设备优化的页面(即为了让你能够在 Google 搜索结果里秒开这个页面),如果你希望参与 V2EX 社区的讨论,你可以继续到 V2EX 上打开本讨论主题的完整版本。
V2EX 是创意工作者们的社区,是一个分享自己正在做的有趣事物、交流想法,可以遇见新朋友甚至新机会的地方。
V2EX is a community of developers, designers and creative people.