1、控制台修改:
alter database databasename character set utf8;
查看编码格式:
show variables like 'character_set_database';
修改已经生成的表的编码格式:
alter table table_name character set utf8;(或者在建表的时候设置:create database databasename character set utf8)
Mysql安装目录下 修改默认的编码格式:配置文件MySQL Server\my.ini
default-character-set=latin1(修改为utf8)
URL中指定编码格式:
Connnection conn=DriverManager.getConntion(jdbc:mysql://localhost:3306/databasename?unicode=true&characterEncodeing=UTF-8,"root","admin");
Tomcat的server.xml中修改GET方式获取添加URIEncoding参数,指定为UTF-8(默认 为:ISO-8859-1)
<Connnection port="8080" propocol="HTTP/1.1"
connectionTimeout="2000"
redirectPort="8443" URIEncoding="UTF-8">