mysql 还原 编码问题_Mysql 之 编码问题

学习ThinkPHP时，中文插入乱码;

1)网页上设置了utf-8;

2)数据库设置'DB_CHARSET'=>'UTF-8';

3)Mysql建表用的也是CHARSET=utf8;

但是结果在Mysql中查看还是乱码。

查看数据库的编码方式

mysql> show variables like 'character\_set\_%';

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

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

| character_set_system | utf8 |

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

7 rows in set (0.24 sec)

之前以为以下四个保持一致就可以了，但是发现退出mysql再次进入之后，编码方式又变回到latin1。

set character_set_client=utf8;

set character_s