【请教】关于mysql的character_set的问题

Question

通过两台linux的mysql客户端连接之后的show variables like 'cha%';结果不一样.A台服务器结果
mysql> show variables like 'cha%';
+--------------------------+--------------------------------------+
| Variable_name            | Value                                |
+--------------------------+--------------------------------------+
| character_set_client     | latin1                               |
| character_set_connection | latin1                               |
| character_set_database   | utf8                                 |
| character_set_filesystem | binary                               |
| character_set_results    | latin1                               |
| character_set_server     | utf8                                 |
| character_set_system     | utf8                                 |
| character_sets_dir       | /usr/local/mysql/var/mysql/charsets/ |
+--------------------------+--------------------------------------+
8 rows in set (0.00 sec)
B台服务器的结果
mysql> show variables like 'cha%';
+--------------------------+--------------------------------------+
| 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/var/mysql/charsets/ |
+--------------------------+--------------------------------------+
8 rows in set (0.00 sec)mysql>请问这是什么愿意呢?
我在安装有客户端的服务器上修改哪些配置才可以设置成utf8.

Answer 1

晕.. 自问自答.. 找到了..客户端的
/etc/my.cnf
这个文件加上
[mysql]
default-character-set=utf8
就可以了.但是现在用php查数据库查出来的非英文字段全显示为问号... 挺奇怪的..

Answer 2

对比下两台服务器上的my.cnf文件

Answer 3

谢谢, mysql客户端连接后的characterset是一样了.
但是用php连接后还是乱码. 这个跟mysql客户端有关系吗? 还是和php-mysql有关系. 如果是那在哪里可以改配置啊.

Answer 4

http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL 中文显示乱码

Answer 5

修改my.cnf
default-character_set=utf-8

Answer 6

好的, 谢谢. 我先看看.
主要是php去的数据库结果的时候, 非英文字段全部显示成 ??? 问号.
刚开始以为和mysql客户端有关系的..