Loading non-ascii characters with mysql infile

Asked Dec 18 '12 at 05:39

Active Dec 18 '12 at 05:39

Viewed 429 times

I have a utf-8_general_ci column. When I insert a column via "INSERT INTO mytable (column) value ('MÃLL')" everything is fine and the row gets inserted.

I am trying to do bulk inserts with the infile command, but it fails on the non-ascii characters and cuts the name off...the value in the database ends up being 'M' rather than 'MÃLL'

The text file I am loading from has the correct value. Here is my statement:

LOAD DATA INFILE 'file.txt' IGNORE INTO table mytable FIELDS TERMINATED BY '$' ESCAPED BY '' LINES TERMINATED BY '\n' (column)

I get the following warning: Warning: Incorrect string value: '\xC3O ...' for column 'column' at row 1

How do I load this file correctly?

asked Dec 18 '12 at 05:39

user_78361084

3,538
22
85
147

http://blog.datispars.com/loading-utf8-text-data-into-a-mysql-table/ – Sir Rufo Dec 18 '12 at 06:42
thanks Rufo but that didn't seem to do it. I think you're on the right path with specifying the character set. – user_78361084 Dec 18 '12 at 19:15
https://stackoverflow.com/questions/4957900/loading-utf-8-encoded-text-into-mysql-table this solved for me – camel_case Apr 24 '23 at 22:05

Loading non-ascii characters with mysql infile

0 Answers0