//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;