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,不是很理解。有知道的朋友告一声!
相关推荐
CoderToy 2020-11-16
emmm00 2020-11-17
王艺强 2020-11-17
ribavnu 2020-11-16
bianruifeng 2020-11-16
wangshuangbao 2020-11-13
苏康申 2020-11-13
vivenwan 2020-11-13
moyekongling 2020-11-13
云中舞步 2020-11-12
要啥自行车一把梭 2020-11-12
aydh 2020-11-12
kuwoyinlehe 2020-11-12
minerk 2020-11-12
vitasfly 2020-11-12
jazywoo在路上 2020-11-11
敏敏张 2020-11-11
世樹 2020-11-11