windows到linux的mysql乱码问题解决方法

//usr/share/mysql/my-small.cnf 拷贝到/etc目录下,改名为my.cnf,再在文件中添加

[mysqld] 

default-character-set=UTF8

[client]

default-character-set=UTF8

[mysql.server]

user=mysql

basedir=/var/lib

default-character-set=utf8

重启mysql服务

show variables like 'character_set_%";

show variables like "collation_%";

set name 'UTF8';

 

用powerbuilder将windows数据导出成文本后,另将文本另存为UTF8格式,然后存入Linux,用

Load data local infile '/root/zny/longjp/address' into tables address;