解决mysql中文乱码的问题

最近在使用idea写项目，往数据库保存中文时出现中文乱码问题。网上百度一番之后，终于完美解决。现将解决方法总结如下，一步一步检查你肯定可以解决乱码问题。大致分六步：

第一步：检查idea自身编码方式，将idea的编码方式全部设置成utf8。

第二步：检查配置文件的编码，在连接数据库的配置语句后面加上

 

?useUnicode=true&characterEncoding=UTF-8

 第三步：检查数据库编码，将编码方式设置成utf8。

第四步：检查mysql的字符集是否为utf8。（我就是卡在这！）

使用命令  show variables like 'char%';

 

如果你的字符集编码不是utf8，则需要修改配置文件并且重启才能使字符集编码为utf8（一定要重启）。具体操作如下：

找到mysql 的配置文件（mysql5.6为my-default.ini）,做如下修改

复制my-default.ini文件，重命名为my.ini；这样根目录下就有两个.ini文件了，一个是my-default.ini，一个是my.ini。接下来我们只需修改my.ini里面的内容就行了； 

主要就是添加上面画红框的地方，完整的配置如下： 

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.

[mysqld]

# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M

# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin

# These are commonly set, remove the # and set as required.
# basedir =E:\mysql5.6\mysql-5.6.40-winx64\mysql-5.6.40-winx64
# datadir = E:\mysql5.6\mysql-5.6.40-winx64\mysql-5.6.40-winx64\data
# port = .....
# server_id = .....

character_set_server=utf8

# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M 

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES 

[client]

default-character-set=utf8

保存后重启，使用show variables like 'char%'; 就可以看到字符集已经修改为utf8了。 

第五步：如果你的是web项目的话，则需要在你的web.xml文件中加上如下配置

<filter>
    <filter-name>encodingFilter</filter-name>
    <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
    <init-param>
        <param-name>encoding</param-name>
        <param-value>UTF-8</param-value>
    </init-param>
    <init-param>
        <param-name>forceEncoding</param-name>
        <param-value>true</param-value>
    </init-param>
</filter>
<filter-mapping>
    <filter-name>encodingFilter</filter-name>
    <url-pattern>/*</url-pattern>
</filter-mapping>

第六步：是浏览器编码问题

参考一下这篇文章：https://blog.csdn.net/u014079773/article/details/52637057 

以上便是mysql乱码问题的解决步骤，希望对你有所帮助。