mysql数据乱码

Question

数据库在替换时出现了乱码，当时没发现，一段时间以后才发现，可是之前的原数据已经没了，不知道还能恢复处理吗？求各位大侠帮帮忙，

Answer 1

set names 'gbk'; 试一下。或者按下贴中方法进行检查并贴出结果以供分析。http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL 中文显示乱码

Answer 2

D:\iisSrv\mysql\bin>mysql -h localhost -u cnymys -p
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>

Answer 3

我设置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)

Answer 4

show create table 贴在哪儿了？