MySQL数据库中文乱码解决方法

1.乱码实例如下:

mysql> select * from table_user;
+--------+---------+--------+---------+--------------+----------+
| userId | comName | tel | address | employeeName | bussName |
+--------+---------+--------+---------+--------------+----------+
| 10 | ?????? | 456 | ?? | ? | ??? |
| 19 | a | a | a | a | ??? |
| 20 | b | b | b | b | ??? |
| 21 | c | c | c | c | ??? |
| 25 | g | g | g | g | ??? |
| 27 | i | i | i | i | ??? |
| 45 | w | w | w | w | ??? |
| 46 | e | e | e | e | ??? |
| 47 | ewe | wew | wew | we | ??? |
| 48 | 23 | 23 | 23 | 23 | ??? |
| 49 | 454 | 454 | 454 | 545 | ??? |
| 50 | yuyui | yuyu | yuy | uyu | ??? |
| 51 | yiyui | yiyiuy | iyi | y | ??? |
| 52 | 55555 | uiui | uiui | uiu | ??? |
| 56 | hgh | ghg | gh | gh | ??? |
| 57 | ghghgh | ghgh | ghgh | ghg | ??? |
| 58 | gjghj | tytyr | tert | er | ??? |
| 59 | qrqewr | qrwe | qwre | qrw | ??? |
| 60 | ??? | ??? | ?? | ? | ??? |
| 61 | 1 | 1 | 1 | 1 | 1 |
| 62 | ?? | 1 | 1 | 1 | 1 |
| 63 | ?? | 1 | 1 | 1 | 1 |
| 64 | ?? | 1 | 1 | 1 | 1 |
+--------+---------+--------+---------+--------------+----------+
23 rows in set (0.00 sec)

2.查询数据库编码如下:

mysql> status;
--------------
C:\Program Files\MySQL\MySQL Server 5.1\bin\mysql.exe Ver 14.14 Distrib 5.1.32,
for Win32 (ia32)

Connection id: 1
Current database:
Current user: root@localhost
SSL: Not in use
Using delimiter: ;
Server version: 5.1.32-community MySQL Community Server (GPL)
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
TCP port: 3306
Uptime: 52 min 31 sec

Threads: 1 Questions: 4 Slow queries: 0 Opens: 15 Flush tables: 1 Open tabl
es: 0 Queries per second avg: 0.1
--------------

3.改变数据库编码

mysql> charset gbk;
Charset changed
mysql> status;
--------------
C:\Program Files\MySQL\MySQL Server 5.1\bin\mysql.exe Ver 14.14 Distrib 5.1.32,
for Win32 (ia32)

Connection id: 1
Current database:
Current user: root@localhost
SSL: Not in use
Using delimiter: ;
Server version: 5.1.32-community MySQL Community Server (GPL)
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: latin1
Db characterset: latin1
Client characterset: gbk
Conn. characterset: gbk
TCP port: 3306
Uptime: 53 min 5 sec

Threads: 1 Questions: 7 Slow queries: 0 Opens: 15 Flush tables: 1 Open tabl
es: 0 Queries per second avg: 0.2
--------------

4.乱码解决:

mysql> select * from table_user;
+--------+--------------+--------+---------+--------------+----------+
| userId | comName | tel | address | employeeName | bussName |
+--------+--------------+--------+---------+--------------+----------+
| 10 | 滨州购物广场 | 456 | 滨州 | 张 | 购物业 |
| 19 | a | a | a | a | 餐饮业 |
| 20 | b | b | b | b | 餐饮业 |
| 21 | c | c | c | c | 餐饮业 |
| 25 | g | g | g | g | 餐饮业 |
| 27 | i | i | i | i | 餐饮业 |
| 45 | w | w | w | w | 购物业 |
| 46 | e | e | e | e | 购物业 |
| 47 | ewe | wew | wew | we | 购物业 |
| 48 | 23 | 23 | 23 | 23 | 购物业 |
| 49 | 454 | 454 | 454 | 545 | 购物业 |
| 50 | yuyui | yuyu | yuy | uyu | 购物业 |
| 51 | yiyui | yiyiuy | iyi | y | 购物业 |
| 52 | 55555 | uiui | uiui | uiu | 餐饮业 |
| 56 | hgh | ghg | gh | gh | 购物业 |
| 57 | ghghgh | ghgh | ghgh | ghg | 购物业 |
| 58 | gjghj | tytyr | tert | er | 购物业 |
| 59 | qrqewr | qrwe | qwre | qrw | 购物业 |
| 60 | 凤飞飞 | 凤飞飞 | 方法 | 飞 | 购物业 |
| 61 | 1 | 1 | 1 | 1 | 1 |
| 62 | 你好 | 1 | 1 | 1 | 1 |
| 63 | 你好 | 1 | 1 | 1 | 1 |
| 64 | 你好 | 1 | 1 | 1 | 1 |
+--------+--------------+--------+---------+--------------+----------+
23 rows in set (0.03 sec)

总结:经分析,解决MySQL数据库中文乱码的方法如下:

只要保持

Client characterset: gb2312(gbk)
Conn. characterset: gb2312(gbk)

编码一致即可。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值