javaweb向数据库写入mysql数据出现中文乱码

2025-04-15 10:28:54
推荐回答(1个)
回答1:

你看看你mysql数据库编码是不是utf-8
在mysql中运行
show variables like 'character%';
+--------------------------+---------------------------------------------------------+
| Variable_name | Value |
+--------------------------+---------------------------------------------------------+
| character_set_client | utf8 |
| character_set_connection | utf8 |
| character_set_database | utf8 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | utf8 |
| character_set_system | utf8 |
| character_sets_dir | C:\Program Files\MySQL\MySQL Server 5.6\share\charsets\ |
+--------------------------+---------------------------------------------------------+
8 rows in set (0.00 sec)
看看你的编码 mysql默认是latin1

打开mysql安装目录,里面有个my.ini文件,
打开这个文件,里面有两处字符集的设置,默认是拉丁,
建议你所想改的,如:utf8或gbk
然后启动mysql服务,
以后创建的数据库默认字符集就是ok了
(重启时,打开MySQLAdministrator的Service Control进行操作就可以了。)