SQL - LOAD DATA INFILE - UTF8 issue

问题:

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?

回答1:

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

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