MySQL Bugs: #10195: LOAD DATA INFILE and UTF-8

The following works for me on Windows MySql 4.1.8-nt and is far less drastic than dropping and rebuilding your database. Before executing the LOAD DATA INFILE-command set the following variable (assuming you want to import an UTF-8 character set file): SE

bugs.mysql.com