Linux mysql 还是中文乱码

Question

我的my.cnf是这么配置的
[client]
#password       = your_password
port            = 3305    #3306
socket          = /tmp/mysql.sock
default-character-set=utf8[mysqld]
port            = 3305#3306
socket          = /tmp/mysql.sock
skip-locking
key_buffer = 256M
max_allowed_packet = 1M
table_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M
default-character-set=utf8数据库显示
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     | utf8                                                       | 
| character_set_system     | utf8                                                       | 
| character_sets_dir       | /usr/local/mysql-5.1.34-linux-i686-glibc23/share/charsets/ | 
+--------------------------+------------------------------------------------------------+
8 rows in set (0.00 sec)还是乱啊，而且，我用php访问时就是乱码insert into testbd value(3,'鍟?);，可是我写的可不是乱码
服务器上的也是乱码，但是现实的却不是一样的乱码郁闷啊，帮忙看看啊

Answer 1

|   3 | 氓猗艩     | 这是数据库里显示的
我php写的是$strmb_inst = "insert into testbd value(3,'啊');";

Answer 2

1. 把这句在你的msyql> insert into testbd value(3,'啊'); 试一下。
2. php中执行一下 mysql_query("set name 'utf8'"); http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL 中文显示乱码http://topic.csdn.net/u/20090513/09/9ff145ac-8c3a-4f6b-9a15-aa931d9d8c2d.html
征集MySQL 乱码现象


Answer 3

1. 把这句在你的msyql> insert into testbd value(3,'啊');  测试的结果是不能显示，是空白在中文部分
2. php中执行一下 mysql_query("set name 'utf8'"); 
用了这句之后，相应位置显示的是？

Answer 4

mysql> show create table testbd;
+--------+-----------------------------------------------------------------------------------------------------------------------+
| Table  | Create Table                                                                                                          |
+--------+-----------------------------------------------------------------------------------------------------------------------+
| testbd | CREATE TABLE `testbd` (
  `sid` int(11) NOT NULL,
  `sname` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 | 
+--------+-----------------------------------------------------------------------------------------------------------------------+mysql> show full columns from testbd;
+-------+-------------+-----------------+------+-----+---------+-------+---------------------------------+---------+
| Field | Type        | Collation       | Null | Key | Default | Extra | Privileges                      | Comment |
+-------+-------------+-----------------+------+-----+---------+-------+---------------------------------+---------+
| sid   | int(11)     | NULL            | NO   |     | NULL    |       | select,insert,update,references |         | 
| sname | varchar(50) | utf8_general_ci | NO   |     | NULL    |       | select,insert,update,references |         | 
+-------+-------------+-----------------+------+-----+---------+-------+---------------------------------+---------+
2 rows in set (0.00 sec)php中执行一下 mysql_query("set name 'gbk'"); my.cnf 里面都是utf8
不好用啊[mysql]
default-character-set=gbk从4. phpmyadmin里乱码
开始就不知道怎么开始了，找不到phpmyadmin，能否指点一下，多谢！！！