#author("2019-11-06T12:46:07+08:00","default:Admin","Admin") MySQL

查看现在的编码格式 †

[edit]

show variables like '%char%';

得到的查询结果

+--------------------------+---------------------------------------------------------+
| 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                                                    |
| character_sets_dir       | C:\Program Files\MySQL\MySQL Server 5.5\share\charsets\ |
+--------------------------+---------------------------------------------------------+
8 rows in set (0.02 sec)

修改整体的编码 †

[edit]

[mysql]
default-character-set=utf8
[mysqld]
character_set_server = utf8
[client]
default-character-set = utf8

修改后需要重启Mysql服务

再次执行查询命令

show variables like '%char%';

得到以下结果

+--------------------------+---------------------------------------------------------+
| Variable_name            | Value                                                   |
+--------------------------+---------------------------------------------------------+
| character_set_client     | latin1                                                  |
| character_set_connection | latin1                                                  |
| character_set_database   | utf8                                                    |
| character_set_filesystem | binary                                                  |
| character_set_results    | latin1                                                  |
| character_set_server     | utf8                                                    |
| character_set_system     | utf8                                                    |
| character_sets_dir       | C:\Program Files\MySQL\MySQL Server 5.5\share\charsets\ |
+--------------------------+---------------------------------------------------------+
8 rows in set (1.02 sec)

修改一个数据库的编码 †

[edit]

use app_relation;

修改数据库编码的命令为：
alter database app_relation character set utf8;

コメント：

お名前:

(画像の文字列を入力して下さい)