MySQL5.5 中文无法输入问题解决

最新推荐文章于 2023-03-09 08:13:49 发布

转载最新推荐文章于 2023-03-09 08:13:49 发布 · 397 阅读

1 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/Gatsby/archive/2013/04/26/3045078.html

文章标签：

#数据库 #网络

本文介绍如何在MySQL中正确配置字符集以支持中文显示。通过修改MySQL配置文件my.ini中的字符集选项，并重启MySQL服务，可以确保数据库能正常读写中文数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

mysql> status; //查看数据库状态
--------------
c:/wamp/bin/mysql/mysql5.5.8/bin/mysql.exe Ver 14.14 Distrib 5.5.8, for Win32 (
x86)

Connection id:          2
Current database:
Current user:
SSL:                    Not in use
Using delimiter:        ;
Server version:         5.5.8-log 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:                 1 min 44 sec

Threads: 1 Questions: 16 Slow queries: 0 Opens: 35 Flush tables: 1 Open tab
les: 28 Queries per second avg: 0.153
--------------

看到字符集是lantin1时，则需设置gbk后才能显示中文（不然显示将是一串??????）
打开MySQL配置文件my.ini，随意找块空白贴上下面四行：

[client]
default-character-set = gbk
[mysqld]
character-set-server = gbk

重启mysql，进入mysql> status; //再次查看

--------------
c:/wamp/bin/mysql/mysql5.5.8/bin/mysql.exe Ver 14.14 Distrib 5.5.8, for Win32 (
x86)

Connection id:          3
Current database:
Current user:
SSL:                    Not in use
Using delimiter:        ;
Server version:         5.5.8-log MySQL Community Server (GPL)
Protocol version:       10
Connection:             localhost via TCP/IP
Server characterset:    gbk
Db     characterset:    gbk
Client characterset:    gbk
Conn. characterset:    gbk
TCP port:               3306
Uptime:                 6 min 10 sec

Threads: 1 Questions: 19 Slow queries: 0 Opens: 35 Flush tables: 1 Open tab
les: 28 Queries per second avg: 0.51

--------------

OK，此时，已可以向数据库输入中文！

转载于:https://www.cnblogs.com/Gatsby/archive/2013/04/26/3045078.html