mysql - 如何修改mysql数据库的字符集

Question

我转储了 MySQL 数据库中的所有 character_set_* 变量，因为我希望 MySQL 具有“utf8”字符集。但即使在使用set names命令之后，也只有少数变量发生了变化。我的配置正确吗？

mysql> SHOW VARIABLES LIKE 'character\_set\_%';
+--------------------------+--------+
| Variable_name            | Value  |
+--------------------------+--------+
| character_set_client     | latin1 |
| character_set_connection | latin1 |
| character_set_database   | latin1 |
| character_set_filesystem | binary |
| character_set_results    | latin1 |
| character_set_server     | latin1 |
| character_set_system     | utf8   |
+--------------------------+--------+
7 rows in set (0.29 sec)

mysql> set names utf8;
Query OK, 0 rows affected (0.29 sec)

mysql> SHOW VARIABLES LIKE 'character\_set\_%';
+--------------------------+--------+
| Variable_name            | Value  |
+--------------------------+--------+
| character_set_client     | utf8   |
| character_set_connection | utf8   |
| character_set_database   | latin1 |
| character_set_filesystem | binary |
| character_set_results    | utf8   |
| character_set_server     | latin1 |
| character_set_system     | utf8   |
+--------------------------+--------+
7 rows in set (0.29 sec)

Answer 1

更改数据库 your_db_name 字符集 utf8；