mysql查找用utf8显示_mysql搜索的UTF8编码汉字错乱问题

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       | /usr/share/mysql/charsets/ |

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

8 rows in set (0.01 sec)

mysql> set character_set_client = utf8;

Query OK, 0 rows affected (0.02 sec)

mysql> set character_set_connection = utf8;

Query OK, 0 rows affected (0.00 sec)

mysql> set character_set_results = utf8;

Query OK, 0 rows affected (0.00 sec)

mysql> show variables like '%character_%';

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

| Variable_name            | Value                      |

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

| character_set_client     | utf8                       |

| character_set_connection | utf8                       |

| character_set_database   | latin1                     |

| character_set_filesystem | binary                     |

| character_set_results    | utf8                       |

| character_set_server     | latin1                     |

| character_set_system     | utf8                       |

| character_sets_dir       | /usr/share/mysql/charsets/ |

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

8 rows in set (0.00 sec)

mysql>

最后再执行你的查询就可以了。

2009年12月29日 10:27