Question

如何解决MySQL 5.5的中文乱码问题

Answer 1

设置数据库的字符集utf-8
设置MySQL的字符集
1、查看MySQL的字符集
SHOW VARIABLES LIKE 'character%';
+--------------------------+---------------------------------+

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

| character_sets_dir | D:"mysql-5.0.37"share"charsets" |

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

2、设置永久：
vim /etc/my.ini
添加：default-character-set = utf8
character_set_server = utf8
设置临时：
mysql> SET character_set_client = utf8 ;

mysql> SET character_set_connection = utf8 ;

mysql> SET character_set_database = utf8 ;

mysql> SET character_set_results = utf8 ;

mysql> SET character_set_server = utf8 ;

3、查询语句临时设置：
set names utf8;
相当于下面的三句指令：
SET character_set_client = utf8;

SET character_set_results = utf8;

SET character_set_connection = utf8;

Answer 2

字符编码问题，中午推荐将编码设置为utf8