tomcat 部署应用乱码解决问题记录.pdf

tomcat 部署应用乱码解决问题记录 1.确认一下页面设置编码utf 8 headmeta http-equiv=Content-Type content=text/html; charset=utf-8 //head 2.mysql连接设置编码没有 j dbc:mysql://30:3306/court_j udge?useUnicode=truecharacterEncoding=utf 8 3.tomcat xml里面设置uriencoding 编码 Connector port=8 8 maxThreads=15 minSpareThreads=25 maxSpareThreads=75 enableLookups=false redirectPort=8443 acceptCount=1 connectionTimeout=2 disableUploadTimeout=true URIEncoding=utf-8 / 4.mysql 自身编码设置 （window s 和linux 有区别 ） a、查看mysql编码(默认latin1) show variables like collation_%; +++ | Variable_name | Value | +++ | character_set_client | latin1 | | character_set_connection | latin1 | | character_set_database | latin1 | | character_set_filesystem | binary | | character_set_results | latin1 | | character_set_server | latin1 | | character_set_system | utf8 | | character_sets_dir | usr share mysql charsets | +++ b、动态设置 （略）下面讲讲修改mysql配置 win系统: mysql目录下my.ini [client] port=3306 default-character-set=utf8 #客 端字符类型，与服务端一致就行，建议utf8 [mysqld] port=3306 character_set_server=utf8 #服务端字符类型，建议utf8 basedir=D: MySql mysql-5.6.17-winx64 #解压根目录 datadir=D: MySql mysql-5.6.17-winx64 data #解压根目录 data sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES [WinMySQLAdmin] D: MySql mysql-5.6.17-winx64 bin mysqld.exe #解压根目录 bin mysqld.exe linux系统 $ vi etc f [mysqld] default-character-set=utf8 character_set_server=utf8 init_connect=SET NAMES utf8 datadir= var lib mysql socket= var lib mysql mysql.sock user=mysql # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 [mysql] default-character-set=utf8 [musql.server] default-character-set=utf8 [client] default-character-set=utf8 [mysqld_safe] default-character-set=utf8 log-error= var log mysqld.log pid-file= var run mysqld mysqld.pid c、查看修改后mysql的编码 mysql show variables like character_set_%; +++ | Variable_name