Re: Character set/Collation problem in MySQL 4.1

[Eddie Moojen]

Found this:
Just short note for everybody who has problem with LOAD DATA INFILE and
correct charset of the file. Loaded file must have SAME charset as *DATABASE*
which contains target table of LOAD DATA command. *Target table charset*
DOESN'T matter.

I didn't find any note about it in manual but I think it is
useful to know it.

Also once you got it imported in the *DATABASE* you move the data arround it seems without too much problems:
insert into db_utf.table_utf select * from db_chrst1.tbl_chrst1;