mysql字符集设置过程（仅供参考）

Administrator@iZpsf1bwhltb8oZ d:\mysql# mysql -uroot -pEnter password: *************
Welcome to the MariaDB monitor. Commands end with ;
or \g.Your MariaDB connection id is 2Server version: 10.1.37-MariaDB mariadb.org binary distributionCopyright © 2000, 2018, Oracle, MariaDB Corporation Ab and others.Type ‘help;
’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.
MariaDB [(none)]> show variables like ‘%char%’;
±-------------------------±-------------------------------+
| Variable_name | Value |
±-------------------------±-------------------------------+
| character_set_client | gbk |
| character_set_connection | gbk |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | gbk |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | D:\mysql\share\charsets\
|±-------------------------±-------------------------------+
8 rows in set (0.00 sec)
MariaDB [(none)]>
show variables like ‘%char%’;
ERROR 2006 (HY000): MySQL server has gone awayNo connection. Trying to reconnect…Connection id: 2Current database: *** NONE ***
±-------------------------±-------------------------------+
| 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 |D:\mysql\share\charsets\ |
±-------------------------±-------------------------------+
8 rows in set (0.00 sec)
MariaDB [(none)]>
show variables like ‘%char%’;
ERROR 2006 (HY000): MySQL server has gone awayNo connection. Trying to reconnect…Connection id: 2Current database: *** NONE ***
±-------------------------±-------------------------------+
| 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 | D:\mysql\share\charsets\ |
±-------------------------±-------------------------------+
8 rows in set (0.01 sec)
MariaDB [(none)]>
show variables like ‘collation%’;
±---------------------±----------------+
| Variable_name | Value |
±---------------------±----------------+
| collation_connection | utf8_unicode_ci |
| collation_database | utf8_unicode_ci |
| collation_server | utf8_unicode_ci |
±---------------------±----------------+
3 rows in set (0.00 sec)MariaDB [(none)]>
show variables like ‘%char%’;
ERROR 2006 (HY000): MySQL server has gone awayNo connection. Trying to reconnect…Connection id: 2Current database: *** NONE ***
±-------------------------±-------------------------------+
| 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 | D:\mysql\share\charsets\ |
±-------------------------±-------------------------------+
8 rows in set (0.01 sec)MariaDB [(none)]>
show variables like ‘collation%’;
±---------------------±----------------+
| Variable_name | Value |
±---------------------±----------------+
| collation_connection | utf8_unicode_ci |
| collation_database | utf8_unicode_ci |
| collation_server | utf8_unicode_ci |
±---------------------±----------------+
3 rows in set (0.00 sec)
Administrator@iZpsf1bwhltb8oZ
d:\xampp# mysql -uroot -pEnter password: *************
Welcome to the MariaDB monitor. Commands end with ;
or \g.Your MariaDB connection id is 2Server version: 10.1.37-MariaDB mariadb.org binary distributionCopyright © 2000, 2018, Oracle, MariaDB Corporation Ab and others.Type 'help;
’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.MariaDB [(none)]> show variables like ‘%char%’;
±-------------------------±-------------------------------+
| Variable_name | Value |
±-------------------------±-------------------------------+
| character_set_client | gbk |
| character_set_connection | gbk |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | gbk |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir |
D:\xampp\mysql\share\charsets\ |
±-------------------------±-------------------------------+
8 rows in set (0.00 sec)MariaDB [(none)]>
show variables like ‘%char%’;
ERROR 2006 (HY000): MySQL server has gone awayNo connection. Trying to reconnect…Connection id: 2Current database: *** NONE ***
±-------------------------±-------------------------------+
| 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 | D:\mysql\share\charsets\ |
±-------------------------±-------------------------------+
8 rows in set (0.00 sec)MariaDB [(none)]>
show variables like ‘%char%’;
ERROR 2006 (HY000): MySQL server has gone awayNo connection. Trying to reconnect…Connection id: 2Current database: *** NONE ***
±-------------------------±-------------------------------+
| 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 | D:\mysql\share\charsets\ |
±-------------------------±-------------------------------+
8 rows in set (0.01 sec)MariaDB [(none)]>
show variables like ‘collation%’;
±---------------------±----------------+
| Variable_name | Value |
±---------------------±----------------+
| collation_connection | utf8_unicode_ci |
| collation_database | utf8_unicode_ci |
| collation_server | utf8_unicode_ci |
±---------------------±----------------+
3 rows in set (0.00 sec)MariaDB [(none)]> show variables like ‘%char%’;
ERROR 2006 (HY000): MySQL server has gone awayNo connection. Trying to reconnect…Connection id: 2Current database: *** NONE ***
±-------------------------±-------------------------------+
| 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 |
D:\mysql\share\charsets\ |
±-------------------------±-------------------------------+
8 rows in set (0.01 sec)MariaDB [(none)]>
show variables like ‘collation%’;
±---------------------±----------------+
| Variable_name | Value |
±---------------------±----------------+
| collation_connection | utf8_unicode_ci |
| collation_database | utf8_unicode_ci |
| collation_server | utf8_unicode_ci |
±---------------------±----------------+
3 rows in set (0.00 sec)