mysql 繁体中文乱码

Question

现在运行的SERVER环境为LINUX，读写中文到数据库都OK，因为不能进机房，我远程用WIN系统的NAVICAT查看数据库却发现中文全都是乱码，包括导出SQL也一样，以至于移植到WIN的显示也是乱码。PHP里已经做了繁体中文和UTF-8的转换，建表也都是用UTF8，WIN下的PHP读写数据库中文也都OK，只是之前副本的数据繁体中文为乱码，请问有什么办法可以转换么？

Answer 1

按下贴中的方法贴出你的检查结果。http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL 中文显示乱码

Answer 2

因为我拿不到现在运行SERVER的ROOT权限，所以我用DUMPSQL的建表语句代替了CREATE TABLE `tbl_clients` (
  `iCustomer_Id` bigint(15) unsigned NOT NULL auto_increment,
  `sCustomer_Name` varchar(200) NOT NULL default '',
  `iFK_Nature_Code` int(11) NOT NULL default '0',
  `sRe` text,
  `dEntry_Date` datetime NOT NULL,
  `sEntry_User` varchar(20) NOT NULL default '',
  `dModify_Date` datetime NOT NULL,
  `sModify_User` varchar(20) NOT NULL default '',
  `sStockCode` varchar(20) NOT NULL default ' ',
  PRIMARY KEY  (`iCustomer_Id`),
  KEY `sCustomer_Name` (`sCustomer_Name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;这个是正在运行的SERVER的环境（LINUX下）+--------------------------+----------------------------+
| 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这个是本机环境（WINXP）
+--------------------------+---------------------------------------------------------+
| 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       | C:\Program Files\MySQL\MySQL Server 5.0\share\charsets\ |
+--------------------------+---------------------------------------------------------+
8 rows in set

Answer 3

在插入数据时先执行一句  mysql_query("set names'utf8'");