MySQL Workbench导入CSV字符解码/编码错误



我试图使用MySQL工作台将csv文件导入MySQL表。然而,我一直收到这个字符解码错误:未处理的异常:"charmap"编解码器无法解码位置418中的字节0x81:字符映射到<未定义>

因此,我使用以下MySQL命令直接将文件加载到数据库中:

LOAD DATA LOCAL INFILE [file path]
INTO TABLE mock_word
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY 'rn'
IGNORE 1 ROWS
(Source, Word_ID, OriginalWord, OriginalTranslation, LabWordCategory);

执行时没有任何错误,但当我尝试使用MySQL Workbench将表导出为csv文件时,我得到了一个字符编码错误:

UnicodeEncodeError: 'charmap' codec can't encode character 'x81' in position 35: character maps to <undefined>
ERROR: Export data to file: 'charmap' codec can't encode character 'x81' in position 35: character maps to <undefined>
Failed

MySQL表的字符集/排序规则是utf8mb4/utf8mb4_unicode_ci。csv文件包含语音符号,我认为这可能是造成问题的原因。

我该如何处理这个问题?非常感谢。

下面我已经复制并粘贴了整个csv文件(这里是该文件的链接:https://drive.google.com/file/d/1y8JQc1x1t0erUwsVrv193CjI8FISFlkv/view?usp=sharing)。Word_ID是我使用的主键。

Source,Word_ID,OriginalWord,OriginalTranslation,LabWordCategory
ASG1848,word:ASG1848:002,ahkeya,woman,N
ASG1848,word:ASG1848:003,akuia,woman,N
ASG1848,word:ASG1848:025,owotan okitz,nails,N
AT1967,word:AT1967:078,payóónixkaasi,"when, if it gets broken",V
AT1967,word:AT1967:079,payóónixkaawa,it is broken,V
AT1969,word:AT1969:0265,ayóxkotokaaʔsiyaaʔwa,they became rocks,V
AT1969,word:AT1969:0306,iiksíkimmapiipitsiʔwa,"he is always very kind, he is a very kind person",V
AT1969,word:AT1969:0537,maanʔssíʔwa,"he is young, he is new",V
AT1969,word:AT1969:0697,nítsaayiipitsi,I lie,V
AT1969,word:AT1969:1286,amíxkaata,fish thou!,V
AT1969,word:AT1969:1465,apóónistoota,smash it!,V
AT1969,word:AT1969:2576,nitááʔsiiyàttsyaaʔwa,I made him sneeze,V
AT1969,word:AT1969:3306,áaakitsskixsiʔpyaaʔwa,we (incl) will dry them,V
CU_RVG1930,word:CU_RVG1930:00287,áikapisimiitapaumixkau,he is often fishing alone secretly,V
CU_RVG1930,word:CU_RVG1930:01190,imaχkópiu,he has a big arrow,V
CU_RVG1930,word:CU_RVG1930:02894,ksistuyíu,[it] is warm,V
CU_RVG1930,word:CU_RVG1930:03703,istókimàtsists,drums,N
CU_RVG1930,word:CU_RVG1930:03743,itåχkanáitàpixkitsìi,(the pieces of meat) all became dry,V
CU_RVG1930,word:CU_RVG1930:14905,ksistókúmiu (ksistókómiu),it is warm (of liquids) (in.),V
CU_RVG1930,word:CU_RVG1930:15445,ɑkáukakyapakeua,she is already a wise woman,V
DGF_NJR2017,word:DGF_NJR2017:0001,opóónit!,shatter it!,V
DGF_NJR2017,word:DGF_NJR2017:0002,nitsíípóónii’pa,I broke it,V
DGF_NJR2017,word:DGF_NJR2017:0003,áakopoonistoomáyi,he will smash it (by dropping or throwing it),V
GR1917,word:GR1917:0303,ákéuαm,woman,N
GR1917,word:GR1917:1074,manáke,New-woman,N
GR1917,word:GR1917:1160,mánatåχkàpinausiks,(those) that had (also) a new way of dressing,N
JT1889,word:JT1889:2456,omǔk'o,it is big,V
JT1889,word:JT1889:2457,omǔk'sim,he is big (man),V
JT1889,word:JT1889:3852,ikhitsi'u,it is dry,V
JT1889,word:JT1889:3853,ikhsǐs',dry him,V
JT1889,word:JT1889:3854,ikhsit,dry thou it,V
JT1889,word:JT1889:3856,ikhsu'yiu,he is dry,V
JT1889,word:JT1889:7011,nitǔs'sǔmmosi,I see myself,V
JT1889,word:JT1889:7331,apon'it,smash it,V
JT1889,word:JT1889:7437,epon'ǐmaie,he smashes it,V
JT1889,word:JT1889:7472,nitse'ponip,I smash it,V
JT1889,word:JT1889:8866,ksǐstusǐs',warm him,V
JT1889,word:JT1889:8867,ksǐstusit',warm it,V
JT1889,word:JT1889:8869,ksǐstusu'yit,warm yourself,V
JT1889,word:JT1889:8872,ksǐstusǔk'sǐnni,warming (a third object),N
DGF_NJR2017,word:DGF_NJR2017:0004,ksiistokómssakit!,heat water!,V
DGF_NJR2017,word:DGF_NJR2017:0005,iníkkoyihkaamisa!,scold her!,V
DGF_NJR2017,word:DGF_NJR2017:0006,pottááhkomoosa!,scare the wildfowl into flight for him!,V

在我的例子中,我缺少列名。请确保文件中的列名。

最新更新