ubuntu修改mysql默认编码

1、$sudocp/etc/mysql/my.cnf/etc/mysql/my.cnf_backup_2010-8-23#备份mysql的配置文件2、$sudogedit/etc/mysql/my.cnf[mysql]#SetthedefaultcharactersetUTF-8:default-character-set=utf8[client]#SetthedefaultcharactersetUTF-8:default-character-set=utf8[mysqld]#SetthedefaultcharactersetUTF-8:default-character-set=utf8init_connect='SETNAMESutf8'3、$sudo/etc/init.d/mysqlrestart#重启mysql服务4、mysql-uroot-pEnterpassword:******>\s#查看是否配置成功Clientcharacterset:utf8Servercharacterset:utf8>quit5、修改完以后,用jdbc时,url为:jdbc:mysql://localhost:3306/tyepc?useUnicode=true&characterEncoding=GBK&autoReconnect=true就可以插入中文了。查询也没问题如果encoding为utf8还是不能插入中文,除非用GBK,不是很理解。有知道的朋友告一声!

相关推荐