汉字入库mysql乱码

1.web.xml中增加如下：

<filter>
    <filter-name>CharacterEncodingFilter</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>CharacterEncodingFilter</filter-name>
    <url-pattern>/*</url-pattern>
</filter-mapping>

 

2.mysql 连接url中加入useUnicode=true&characterEncoding=UTF-8

 

3.mysql>show variables like '%char%'；

set character_set_server=utf8;

set character_set_database=utf8;

...

rugu如果不生效   进入mysql安装路径  找到my.ini