由于DolphinDB的字符串采用UTF-8编码,若加载的文件不是UTF-8编码,需在导入后进行转化。DolphinDB提供了convertEncode、fromUTF8和toUTF8函数,用于导入数据后对字符串编码进行转换。加入csv是gbk编码,可以用如下代码对表头进行转换:
fileName="D:\\DolphinDB\\Quote\\000001_20120104.csv" schema1=extractTextSchema(fileName) update schema1 set name=convertEncode(name,"gbk","utf-8") t=ploadText(fileName,,schema1)