语句很简单

 代码如下  

<?php
$connection=mysql_connect("localhost","root","password"); //连接并选择数据库服务器
mysql_select_db("test",$connection);
$query="select * from users where name='你好'";
$result=mysql_query($query,$connection);
while($row=mysql_fetch_array($result))
{
echo "用户ID：".$row[0]."<br>"; //也可以写做$row["user_id"]
echo "用户名：".$row[1]."<br>"; //也可以写做$row["user_name"]
}
?>

　　运行结果提示

　　Error: Illegal mix of collations (gbk_chinese_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='

　　意思是说：操作符“=”比较的字符集不一致，一个是gbk_chinese_ci,一个是latin1_swedish_ci。

　　首先、查看mysql的my.cnf,确认为utf8

 代码如下  

mysql> show variables like "%char%";

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

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

| character_set_system     | utf8                                |

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

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

8 rows in set (0.00 sec)