MySQL 各种乱码! :)

来源：互联网发布：大连网络推广哪家好编辑：程序博客网时间：2024/04/28 00:15

部分转自高人博文

MySQL默认编码是latin1

mysql> show variables like 'character%';

+--------------------------+--------------------------+

| 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 | D:/MySQL/share/charsets/ |

+--------------------------+--------------------------+

my.ini（MySQL配置文件）文件对编码进行修改

设置MySQL的默认字符集为GBK，找到客户端配置[client]在下面添加。

default-character-set=GBK(这是因为，命令行工具默认为GBK)

找到服务器配置[mysqld]在下面添加

default-character-set=utf8

设定MySQL数据库以utf8编码运行，连接MySQL数据库时使用utf8编码

停止和重新启动MySQL

net stop mysql

net start mysql

修改后为

mysql> show variables like 'character%';

+--------------------------+--------------------------+

| Variable_name | Value |

+--------------------------+--------------------------+

| character_set_client | gb2312 |

| character_set_connection | gb2312 |

| character_set_database | utf8 |

| character_set_filesystem | binary |

| character_set_results | gb2312 |

| character_set_server | utf8 |

| character_set_system | utf8 |

| character_sets_dir | D:/MySQL/share/charsets/ |

+--------------------------+--------------------------+