编码相关

1. MySql 编码

show variables like '%char%';

 

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 /usr/share/mysql/charsets/

 

除 character_set_server 更改之后会还原

其他

可用命令 set character_set_client = utf8 来设置

 

修改 mysql 配置文件

my.ini. Linux -- /etc/my.cnf

 

[mysql]

default-character-set = utf8

 

[mysqld]

default-character-set = utf8

character-set-server = utf8

collation-server = utf8_general_ci

init_connect = 'SET collation_connection = utf8_general_ci'

init_connect = 'SET NAMES utf8'

lower_case_table_names = 1

 

[mysql.server]

default-character-set = utf8

 

[mysqld_safe]

 

default-character-set = utf8

 

[client]

default-character-set = utf8

 

重启 mysql

 

2 .tomcat 编码

 server.xml

<Connector port="8080" protocol="HTTP/1.1" 

               connectionTimeout="20000" 

               redirectPort="8443" URIEncoding="UTF-8" />

 

重启 tomcat

 

3. java 

 jstl