中文乱码时正常时坏是怎么回事

我的php代码从mysql数据库里读取中文字，一会正常，一会又不正常，是怎么回事啊？？？？？

解决方案 »

  1.   

    mysql> select * from categories;
    +------------+--------------+
    | categoryid | categoryname |
    +------------+--------------+
    |          1 | 国内新闻 |
    |          2 | 国际新闻 |
    |          3 | 军事新闻 |
    |          4 | 体育新闻 |
    |          5 | 科技新闻 |
    |          6 | 财经新闻 |
    |          7 | 娱乐新闻 |
    |          8 | 社会新闻 |
    +------------+--------------+
    8 rows in set (0.00 sec)mysql> show variables like "char%";
    +--------------------------+----------------------------+
    | 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     | latin1                     |
    | character_set_system     | utf8                       |
    | character_sets_dir       | /usr/share/mysql/charsets/ |
    +--------------------------+----------------------------+
    8 rows in set (0.00 sec)mysql> show full fields from categories;
    +--------------+-------------+-----------------+------+-----+---------+-------+---------------------------------+---------+
    | Field        | Type        | Collation       | Null | Key | Default | Extra | Privileges                      | Comment |
    +--------------+-------------+-----------------+------+-----+---------+-------+---------------------------------+---------+
    | categoryid   | tinyint(3)  | NULL            | YES  |     | NULL    |       | select,insert,update,references |         |
    | categoryname | varchar(20) | utf8_general_ci | NO   |     |         |       | select,insert,update,references |         |
    +--------------+-------------+-----------------+------+-----+---------+-------+---------------------------------+---------+
    2 rows in set (0.00 sec)
    上面是我的情况，我要从categories表中读取中文字，时好时坏。
      

  2.   

    面页，数据库连接，数据库都采用utf-8编码
      

  3.   

    <?php
    require_once("../Connections/new.php");
    mysql_select_db("new");
    $sql1="select categoryid,categoryname from categories";
    $rscategory=mysql_query($sql1) or die(mysql_error());
    $row_rscategory=mysql_fetch_assoc($rscategory);
    $totalrows_rscategory=mysql_num_rows($rscategory);
    ?>
    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    <html xmlns="http://www.w3.org/1999/xhtml">
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /><title>无标题文档</title>
    <style type="text/css">
    <!--
    @import url("style.css");
    -->
    </style>
    </head>
      

  4.   

    数据库连接：
    $con=mysql_connect('localhost','root','1233333') or die(mysql_error());
    mysql_query('set names utf8',$con);