mysqlimport and UTF-8 text import problems
Posted by: Clifford Helsel
Date: August 25, 2005 06:19AM

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?



Options: ReplyQuote

Written By
mysqlimport and UTF-8 text import problems
August 25, 2005 06:19AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.