SQL - LOAD DATA INFILE - UTF8 issue

Question

I get few big database exported to .txt (its around 5GB each) so i found out that i can easy import it with

LOAD DATA LOCAL INFILE '/path/pet.txt' INTO TABLE pet;

it works well but i am having problem with UTF-8 there, because some texts are displaying like PODBÂ¦H Z L DODATELNÂ¦ ZPRACOVAT even that column charset is set for UTF-8 and in .txt file its displayed OK, so problem is somewhere in import. Any idea how can i import it without this problems?

Yea it is. + In .txt file it display right, so there is problem in import process in my opinion — Juraj Polak, Oct 08 '14 at 12:04
`SET character_set_database=utf8; LOAD DATA LOCAL INFILE '/var/www/db/something.txt' INTO TABLE something_table;` Not working :( — Juraj Polak, Oct 08 '14 at 12:29

score 6 · Accepted Answer · edited May 23 '17 at 12:17

6

I found this : Loading utf-8 encoded text into MySQL table

LOAD DATA LOCAL INFILE '/path/pet.txt' 
INTO TABLE pet
CHARACTER SET UTF8;

edited May 23 '17 at 12:17

Community

1
1

answered Oct 08 '14 at 12:33

ôkio

1,772
1
15
16

SQL - LOAD DATA INFILE - UTF8 issue

1 Answers1

Linked