关于sqldf函数读取数据框，出现字段名乱码问题，请专业人员协助解决，谢谢！

4关注
1粉丝

已卖：166份资源

博士生

8%

还不是VIP/贵宾

-

0%

威望: 0 级
论坛币: 2914 个
通用积分: 5.8196
学术水平: 0 点
热心指数: 2 点
信用等级: 0 点
经验: 2168 点
帖子: 136
精华: 0
在线时间: 195 小时
注册时间: 2014-10-20
最后登录: 2021-4-12

楼主

万木青 发表于 2016-12-24 17:32:48 |AI写论文

是否 +2 论坛币

k人参与回答

经管之家送您一份

应届毕业生专属福利!

求职就业群

赵安豆老师微信：zhaoandou666

经管之家联合CDA

送您一个全额奖学金名额~ !

立即领取

感谢您参与论坛问题回答

经管之家送您两个论坛币！

+2 论坛币

下面为相应的脚本与执行结果，str()可以清晰地看清每个字段名，sqldf却出现乱码，求解，谢谢！
在R中的脚本为：
combasedata<-"com-base-data.xls"
basedata<-read.xlsx2(combasedata,1,Encoding="UTF8")

str(basedata)
sqldf("select * from basedata limit 2")#此语出现结果异常，不知为何只有字段名乱码，内容则不会，上面的str（）函数结果却可以清晰地看清每个字段名。

结果：
> str(basedata)
'data.frame':       11456 obs. of  24 variables:
$ 物料号       : Factor w/ 8375 levels "000010","000012",..: 5926 5948 5936 5934 5931 5941 5927 5943 5942 5944 ...
$ 物料名       : Factor w/ 8306 levels "(400MLX2+280MLX1)X8屈臣氏蒸馏水促销装",..: 3788 3776 3787 3779 3791 3780 3789 3785 3783 3781 ...
$ 物料组       : Factor w/ 28 levels "半成品","包装米粉",..: 4 4 4 4 4 4 4 4 4 4 ...
$ 常用单位代码.  : Factor w/ 14 levels "BAG","BOT","BOX",..: 3 3 3 3 3 3 3 3 3 3 ...
$ 常用单位    : Factor w/ 14 levels "EA","袋","吨",..: 12 12 12 12 12 12 12 12 12 12 ...
$ 最小单位代码 : Factor w/ 18 levels "BAG","BOT","BOX",..: 2 7 2 2 2 1 2 7 7 7 ...
$ 最小单位    : Factor w/ 18 levels "EA","包","袋",..: 12 1 12 12 12 3 12 1 1 1 ...
$ 货主代码    : Factor w/ 66 levels "CQSW","CXLE",..: 1 1 1 1 1 1 1 1 1 1 ...
$ 货主名       : Factor w/ 66 levels "昌盛鸿笙食品",..: 3 3 3 3 3 3 3 3 3 3 ...
$ 业务范围    : Factor w/ 5 levels "城配","集团内",..: 1 1 1 1 1 1 1 1 1 1 ...
$ 保质期天.    : Factor w/ 39 levels "","0","10000",..: 30 21 30 21 21 21 30 21 21 21 ...
$ 常用单位重量KG : Factor w/ 836 levels "0.006","0.0075",..: 175 168 175 265 265 261 175 656 656 656 ...
$ 常用单位体积CM3: Factor w/ 2241 levels "0","0.001669",..: 716 1302 716 1390 1390 1075 716 1388 1388 1388 ...
$ 常用转最小比率 : Factor w/ 457 levels "0.00526315789473684",..: 46 6 46 444 444 88 46 288 288 288 ...
$ 仓库          : Factor w/ 4 levels "","W155","WHGZ01",..: 1 1 1 1 1 1 3 1 1 1 ...
$ 库位          : Factor w/ 1 level "": 1 1 1 1 1 1 1 1 1 1 ...
$ 板数          : Factor w/ 10 levels "","0","1","100",..: 1 1 1 1 1 1 2 1 1 1 ...
$ 分类          : Factor w/ 7 levels "","0","A","B",..: 1 1 1 1 1 1 1 1 1 1 ...
$ 参考单位    : Factor w/ 6 levels "","BAG","BOT",..: 4 4 4 4 4 4 4 4 4 4 ...
$ 安全库存    : Factor w/ 8 levels "","0","180","200",..: 1 1 1 1 1 1 2 1 1 1 ...
$ 最大库存    : Factor w/ 8 levels "","0","100","120",..: 1 1 1 1 1 1 2 1 1 1 ...
$ 直发数       : Factor w/ 7 levels "","0","100","32",..: 1 1 1 1 1 1 2 1 1 1 ...
$ 条码          : Factor w/ 3700 levels ""," ","0","0000000000000",..: 2124 2148 2133 2132 2129 2138 2125 2140 2139 2141 ...
$ Encoding    : Factor w/ 1 level "UTF8": 1 1 1 1 1 1 1 1 1 1 ...

> sqldf("select * from basedata limit 2")
Loading required package: tcltk
      鐗╂枡鍙<b7>                            鐗╂枡鍚<8d> 鐗╂枡缁<84> 甯哥敤鍗曚綅浠ｇ爜.
1 cq6937428500055 精力沛牌全价麦胚芽(加卵磷脂）N（425g*12)       产品                BOX
2 cq6937428502318yc          精力沛牌高纤黑麦盒装(980g*10)       产品                BOX
  甯哥敤鍗曚綅鏈