mysql数据乱码 数据库在替换时出现了乱码,当时没发现,一段时间以后才发现,可是之前的原数据已经没了,不知道还能恢复处理吗?求各位大侠帮帮忙, 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 set names 'gbk'; 试一下。或者按下贴中方法进行检查并贴出结果以供分析。http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspxMySQL 中文显示乱码 D:\iisSrv\mysql\bin>mysql -h localhost -u cnymys -pEnter password: ********Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 4317 to server version: 5.0.18-ntType 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql> set names 'gbk';Query OK, 0 rows affected (0.00 sec)mysql> use cnymys;Database changedmysql> select * from dg_admin;+----+----------+----------+------------------------+--------------+---------------+-------------+------------+| id | username | realname | pwd | departmentid | department | mobile | addtime |+----+----------+----------+------------------------+--------------+---------------+-------------+------------+| 2 | cn???? | ???í?± | BV1GWURcTUFcc913bcf7ef | 2 | ???? | 15910178940 | 1235031169 || 3 | test | ???? | CAhQCFcC965eb72c92 | 3 | ???¨???í?± | 15910178941 | 1235031638 |+----+----------+----------+------------------------+--------------+---------------+-------------+------------+2 rows in set (0.03 sec)mysql> set names 'gb2312';Query OK, 0 rows affected (0.00 sec)mysql> select * from dg_admin;+----+----------+----------+------------------------+--------------+---------------+-------------+------------+| id | username | realname | pwd | departmentid | department | mobile | addtime |+----+----------+----------+------------------------+--------------+---------------+-------------+------------+| 2 | cn???? | ???í?± | BV1GWURcTUFcc913bcf7ef | 2 | ???? | 15910178940 | 1235031169 || 3 | test | ???? | CAhQCFcC965eb72c92 | 3 | ???¨???í?± | 15910178941 | 1235031638 |+----+----------+----------+------------------------+--------------+---------------+-------------+------------+2 rows in set (0.02 sec)mysql> set names 'utf8';Query OK, 0 rows affected (0.00 sec)mysql> select * from dg_admin;+----+------------+--------------+------------------------+--------------+----------------------+-------------+------------+| id | username | realname | pwd | departmentid | department | mobile | addtime |+----+------------+--------------+------------------------+--------------+----------------------+-------------+------------+| 2 | cn脪脢脙脡 | 鹿脺脌铆脭卤 | BV1GWURcTUFcc913bcf7ef | 2 | 脧碌脥鲁 | 15910178940 | 1235031169 || 3 | test | 虏芒脢脭 | CAhQCFcC965eb72c92 | 3 |脝脮脥篓鹿脺脌铆脭卤 | 15910178941 | 1235031638 |+----+------------+--------------+------------------------+--------------+----------------------+-------------+------------+2 rows in set (0.00 sec)mysql> show variables like 'collation_%';+----------------------+-------------------+| Variable_name | Value |+----------------------+-------------------+| collation_connection | utf8_general_ci || collation_database | latin1_swedish_ci || collation_server | utf8_general_ci |+----------------------+-------------------+3 rows in set (0.00 sec)mysql> show variables like 'character_set_%';+--------------------------+---------------------------------+| Variable_name | Value |+--------------------------+---------------------------------+| character_set_client | utf8 || character_set_connection | utf8 || character_set_database | latin1 || character_set_results | utf8 || character_set_server | utf8 || character_set_system | utf8 || character_sets_dir | D:\iisSrv\mysql\share\charsets\ |+--------------------------+---------------------------------+7 rows in set (0.00 sec)mysql> 我设置gbk,和gb2312就成问号了,最初就是这样的| 2 | cn脪脢脙脡 | 鹿脺脌铆脭卤 | BV1GWURcTUFcc913bcf7ef | 2 | 脧碌脥鲁 | 15910178940 | 1235031169 || 3 | test | 虏芒脢脭 | CAhQCFcC965eb72c92 | 3 |脝脮脥篓鹿脺脌铆脭卤 | 15910178941 | 1235031638 |应是utf-8的,mysql> show variables like 'collation_%';+----------------------+-------------------+| Variable_name | Value |+----------------------+-------------------+| collation_connection | utf8_general_ci || collation_database | latin1_swedish_ci || collation_server | utf8_general_ci |+----------------------+-------------------+3 rows in set (0.00 sec)mysql> show variables like 'character_set_%';+--------------------------+---------------------------------+| Variable_name | Value |+--------------------------+---------------------------------+| character_set_client | utf8 || character_set_connection | utf8 || character_set_database | latin1 || character_set_results | utf8 || character_set_server | utf8 || character_set_system | utf8 || character_sets_dir | D:\iisSrv\mysql\share\charsets\ |+--------------------------+---------------------------------+7 rows in set (0.00 sec) show create table 贴在哪儿了? mysql经常有show processlist;有很多这二种Status状态?应该是什么原因呢? Ubuntu 用sqlite3创建数据库 如何更高效的写出这条SQL语句 MYSQL数据导入问题 MySql 数据库文件释放问题。 任命 yueliangdao0608 为本版 版主 为何在MySQL中建立这个索引会出错??? 如何设置mysql的wait_timeout参数,如何察看? 请问Tomcat中使用JSP如何连接MYSQL数据库? Foreign key constraint is incorrectly formed 关于mysql群集费用问题 mysql缓存读取
MySQL 中文显示乱码
Enter password: ********
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4317 to server version: 5.0.18-ntType 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql> set names 'gbk';
Query OK, 0 rows affected (0.00 sec)mysql> use cnymys;
Database changedmysql> select * from dg_admin;
+----+----------+----------+------------------------+--------------+------------
---+-------------+------------+
| id | username | realname | pwd | departmentid | department
| mobile | addtime |
+----+----------+----------+------------------------+--------------+------------
---+-------------+------------+
| 2 | cn???? | ???í?± | BV1GWURcTUFcc913bcf7ef | 2 | ????
| 15910178940 | 1235031169 |
| 3 | test | ???? | CAhQCFcC965eb72c92 | 3 | ???¨???í?
± | 15910178941 | 1235031638 |
+----+----------+----------+------------------------+--------------+------------
---+-------------+------------+
2 rows in set (0.03 sec)mysql> set names 'gb2312';
Query OK, 0 rows affected (0.00 sec)mysql> select * from dg_admin;
+----+----------+----------+------------------------+--------------+------------
---+-------------+------------+
| id | username | realname | pwd | departmentid | department
| mobile | addtime |
+----+----------+----------+------------------------+--------------+------------
---+-------------+------------+
| 2 | cn???? | ???í?± | BV1GWURcTUFcc913bcf7ef | 2 | ????
| 15910178940 | 1235031169 |
| 3 | test | ???? | CAhQCFcC965eb72c92 | 3 | ???¨???í?
± | 15910178941 | 1235031638 |
+----+----------+----------+------------------------+--------------+------------
---+-------------+------------+
2 rows in set (0.02 sec)mysql> set names 'utf8';
Query OK, 0 rows affected (0.00 sec)mysql> select * from dg_admin;
+----+------------+--------------+------------------------+--------------+------
----------------+-------------+------------+
| id | username | realname | pwd | departmentid | depar
tment | mobile | addtime |
+----+------------+--------------+------------------------+--------------+------
----------------+-------------+------------+
| 2 | cn脪脢脙脡 | 鹿脺脌铆脭卤 | BV1GWURcTUFcc913bcf7ef |
2 | 脧碌脥鲁 | 15910178940 | 1235031169 |
| 3 | test | 虏芒脢脭 | CAhQCFcC965eb72c92 | 3 |
脝脮脥篓鹿脺脌铆脭卤 | 15910178941 | 1235031638 |
+----+------------+--------------+------------------------+--------------+------
----------------+-------------+------------+
2 rows in set (0.00 sec)mysql> show variables like 'collation_%';
+----------------------+-------------------+
| Variable_name | Value |
+----------------------+-------------------+
| collation_connection | utf8_general_ci |
| collation_database | latin1_swedish_ci |
| collation_server | utf8_general_ci |
+----------------------+-------------------+
3 rows in set (0.00 sec)mysql> show variables like 'character_set_%';
+--------------------------+---------------------------------+
| Variable_name | Value |
+--------------------------+---------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | D:\iisSrv\mysql\share\charsets\ |
+--------------------------+---------------------------------+
7 rows in set (0.00 sec)mysql>
2 | 脧碌脥鲁 | 15910178940 | 1235031169 |
| 3 | test | 虏芒脢脭 | CAhQCFcC965eb72c92 | 3 |
脝脮脥篓鹿脺脌铆脭卤 | 15910178941 | 1235031638 |应是utf-8的,mysql> show variables like 'collation_%';
+----------------------+-------------------+
| Variable_name | Value |
+----------------------+-------------------+
| collation_connection | utf8_general_ci |
| collation_database | latin1_swedish_ci |
| collation_server | utf8_general_ci |
+----------------------+-------------------+
3 rows in set (0.00 sec)mysql> show variables like 'character_set_%';
+--------------------------+---------------------------------+
| Variable_name | Value |
+--------------------------+---------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | latin1 |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | D:\iisSrv\mysql\share\charsets\ |
+--------------------------+---------------------------------+
7 rows in set (0.00 sec)