SQL-LOAD DATA INFILE-UTF8问题 [英] SQL - LOAD DATA INFILE - UTF8 issue

问题描述

我几乎没有导出到.txt的大型数据库(每个数据库约5GB)，所以我发现我可以轻松地用

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

将数据本地INFILE'/path/pet.txt'装入表pet;

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

它工作正常，但我在那儿遇到UTF-8，因为某些文本正在显示，例如PODB，HZL DODATELN，ZPRACOVAT，即使该列字符集设置为UTF-8，在.txt文件中它也显示确定，所以问题是进口的地方.知道如何导入而不会出现此问题吗?

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?

推荐答案

我发现了这一点: 查看全文