set names gbk;
set character_set_database = ‘gbk’;
set character_set_server = ‘gbk’;
show variables like ‘%charac%’;
/*select title from mytable into outfile ‘2.txt’ FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘“’ ESCAPED BY ‘\\’ ;*/
/*Server version: 5.1.40 build number (revision)=IB_4.0.4_r14484_14560(ice)*/
create table b (`title` varchar(256) CHARACTER SET gbk DEFAULT NULL)engine=brighthouse;
create table m (`title` varchar(256) CHARACTER SET gbk DEFAULT NULL)engine=myisam;
load data infile ‘2.txt’ into table m FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘“’ ESCAPED BY ‘\\’ ;
load data infile ‘2.txt’ into table b FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘“’ ESCAPED BY ‘\\’ ;
mysql> load data infile ‘2.txt’ into table m FIELDS TERMINATED BY ‘,’ ENCLOSED
BY ‘“’ ESCAPED BY ‘\\’ ;
Query OK, 1 row affected (0.00 sec)
Records: 1 Deleted: 0 Skipped: 0 Warnings: 0
mysql> load data infile ‘2.txt’ into table b FIELDS TERMINATED BY ‘,’ ENCLOSED
BY ‘“’ ESCAPED BY ‘\\’ ;
ERROR 2 (HY000): Wrong data or column definition. Row: 1, field: 1.
/*USE IEE,set @bh_dataformat=‘mysql’,it runs well*/
2.txt is Attachmented
