CSV utf8使用phpmyadmin导入 [英] CSV utf8 import with phpmyadmin

问题描述

我尝试使用CSV LOAD DATA

导入包含韩语字符的数据集，保存为Unicode编码，即使我将输入字符集设置为utf8 korean

这个列的编码当然是utf8

示例记录p>

  79읽읽读NULL 
  

什么进入MYSQL：

  79ì½ë<¤read NULL 
  
 
 
解决方案
加载数据支持字符集子句
  load data local infile'filename.txt'into table test.unicode CHARACTER SET utf8 
  
如果phpmyadmin忽略它，请从命令行使用它。
 
I am trying to import a dataset with korean characters in, saved as unicode encoding using CSV LOAD DATA

even when I set the input character set to utf8 the korean get's mangled

the encoding for that column is of course utf8

sample record (tab delimited):
79  읽다  read    NULL
what goes into MYSQL:
79  ì½ë‹¤   read    NULL

解决方案
load data supports character set clause
load data local infile 'filename.txt' into table test.unicode CHARACTER SET utf8
Use it from the command line if phpmyadmin ignores it.

                        
这篇关于CSV utf8使用phpmyadmin导入的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！