这台服务器
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)
两个字符集完全相同,版本也一样。为什么同时插入一个中文语句。第一台显示,输出页面却是乱码,第二台不显示却是正常的
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)
两个字符集完全相同,版本也一样。为什么同时插入一个中文语句。第一台显示,输出页面却是乱码,第二台不显示却是正常的
如果没有选择,则默认为数据库的字符集.
应该是| character_set_database | latin1 |建议在mysql中,保存中文使用utf8编码!