wamp mysql乱码_wamp mysql控制台中文显示乱码

原以为my.ini里的设置编码全为utf8不够彻底导致控制台显示中文会乱码，今天才发现发现原来要将客户端的字符集设为GBk才可以解决mysql的中文乱码问题......

mysql> SHOW VARIABLES LIKE 'character_set%';

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

| 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                                 |

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

所有字符几乎的都设为utf8，但是在mysql控制台看到的依然是乱码

于是来一次本质的回归把

mysql> set character_set_results='gbk'; #将编码改为gbk，控制台就可以显示中文了