1、代码编码全部用UTF8,特别是配置用的属性文件
2、JSP页面编码
3、request请求编码
4、数据库jdbc连接编码jdbc:mysql://127.0.0.1:3306/nts?useUnicode=true&characterEncoding=utf8
5、数据库编码
- 查看编码:
- show variables like 'character\_set\_%';
- 创建数据库指定编码:
- create database mydb character set utf-8;#直接指定其编码
- 修改数据库编码:
- set character_set_client=utf8;
- set character_set_connection=utf8;
- set character_set_database=utf8;
- set character_set_results=utf8;
- set character_set_server=utf8;
- alter database mydb character set utf-8;
- set names utf8
- 修改my.cnf文件
- 修改tomcat编码,打开server.xml
- <Connector port="80" protocol="HTTP/1.1"
- connectionTimeout="20000"
- redirectPort="8443" URIEncoding="UTF-8"/>
- 系统编码:
- 乱码文件名恢复
- convmv -f gbk -t utf8 *。*(--notest)