mysql5.0在本機和使用phpmyadmin時編碼不同？ - BBS

我的server目前版本如下：

FreeBSD 4.8 Stable
Mysql server&client：5.0.33
PHP version ：4.4.4
phpMyAdmin：2.9.2

我在本機端登入 mysql 下指令

mysql> show variables like '%character%';
+--------------------------+----------------------------------+
| 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 | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/share/mysql/charsets/ |
+--------------------------+----------------------------------+

若使用phpMyAdmin下 SQL指令：

SQL 語法:SHOW VARIABLES LIKE '%character%'
Variable_name Value
character_set_client latin1
character_set_connection utf8
character_set_database latin1
character_set_filesystem binary
character_set_results latin1
character_set_server latin1
character_set_system utf8
character_sets_dir /usr/local/share/mysql/charsets/


請注意綠色的地方，本機執行和phpmyadmin執行時，
在character_set_client和results的地方不同...
能不能請問一下，該怎麼做才能讓兩邊連接的格式是一樣的呢？

謝謝了^^



--