这台服务器
mysql> show variables like 'character_set_%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | latin1                     | 
| character_set_connection | latin1                     | 
| character_set_database   | latin1                     | 
| character_set_filesystem | binary                     | 
| character_set_results    | latin1                     | 
| character_set_server     | latin1                     | 
| character_set_system     | utf8                       | 
| character_sets_dir       | /usr/share/mysql/charsets/ | 
+--------------------------+----------------------------+
8 rows in set (0.00 sec)mysql> use smsbusiness;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -ADatabase changed
mysql> delete from Smsb_Message;
Query OK, 5 rows affected (0.00 sec)mysql> insert Smsb_Message(dailing,commodity,date,something,FeeType) values ('13007350843','宝马马','2010-11-12','我喜欢二手宝马',1);
Query OK, 1 row affected (0.00 sec)mysql> select *from Smsb_message;
ERROR 1146 (42S02): Table 'smsbusiness.Smsb_message' doesn't exist
mysql> select *from Smsb_Message;
+----+-------------+-----------+------------+----------------+---------+------+
| id | dailing     | commodity | date       | something      | FeeType | memo |
+----+-------------+-----------+------------+----------------+---------+------+
| 52 | 13007350843 | 宝马马    | 2010-11-12 | 我喜欢二手宝马 |       1 | NULL | 
+----+-------------+-----------+------------+----------------+---------+------+
和另一台服务器。
mysql>  show variables like 'character_set_%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | latin1                     | 
| character_set_connection | latin1                     | 
| character_set_database   | latin1                     | 
| character_set_filesystem | binary                     | 
| character_set_results    | latin1                     | 
| character_set_server     | latin1                     | 
| character_set_system     | utf8                       | 
| character_sets_dir       | /usr/share/mysql/charsets/ | 
+--------------------------+----------------------------+
8 rows in set (0.00 sec)mysql> delete from Smsb_Message;
ERROR 1046 (3D000): No database selected
mysql> use smsbusiness;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -ADatabase changed
mysql> delete from Smsb_Message;
Query OK, 5 rows affected (0.00 sec)mysql> insert Smsb_Message(dailing,commodity,date,something,FeeType) values ('13007350843','宝马马','2010-11-12','我喜欢二手宝马',1);
Query OK, 1 row affected, 2 warnings (0.00 sec)mysql> select *from Smsb_Message;
+----+-------------+-----------+------------+----------------+---------+------+
| id | dailing     | commodity | date       | something      | FeeType | memo |
+----+-------------+-----------+------------+----------------+---------+------+
| 77 | 13007350843 | ????   | 2010-11-12 | ?????????????|       1 | NULL | 
+----+-------------+-----------+------------+----------------+---------+------+
1 row in set (0.00 sec)
两个字符集完全相同,版本也一样。为什么同时插入一个中文语句。第一台显示,输出页面却是乱码,第二台不显示却是正常的