mysqlimport and UTF-8 text import problems

[Clifford Helsel]

I recently installed the latest version of MySQL for Windows. I have a UTF-8 based text file containing text, one text item per line. Some of the text records have European accent characters. I am unable to import these lines into my table using the mysqlimport command:

mysqlimport textdb words.txt -uroot -p***** --local -v --default-character-set=utf8 --lines-terminated-by="\r\n" -d

The records with the European characters are skipped.

Any ideas?

Do I need to change something in my.ini, does the source file have to be in a specific format? Also, I'd like to be able import Unicode big-endian formatted text instead of using UTF-8. Is there a way to make the mysqlimport command work with that type of file?

Thanks!

Cliff
[e-mail]