问题

软件 >> MySQL
Questions in category: MySQL (MySQL).

mysql 设置字符集

Posted by haifeng on 2014-05-02 22:25:47 last update 2020-09-29 18:03:43 | Answers (0) | 收藏


mysql> show variables like 'char%';
+--------------------------+----------------------------+
| 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/ |
+--------------------------+----------------------------+

 


WampServer 3.1.4 的默认设置是

mysql> show variables like 'char%';
+--------------------------+-------------------------------------------------+
| Variable_name            | Value                                           |
+--------------------------+-------------------------------------------------+
| character_set_client     | gbk                                             |
| character_set_connection | gbk                                             |
| character_set_database   | utf8mb4                                         |
| character_set_filesystem | binary                                          |
| character_set_results    | gbk                                             |
| character_set_server     | latin1                                          |
| character_set_system     | utf8                                            |
| character_sets_dir       | c:\wamp64\bin\mysql\mysql5.7.23\share\charsets\ |
+--------------------------+-------------------------------------------------+
8 rows in set, 1 warning (0.02 sec)