作者psinqoo (零度空间)
看板R_Language
标题[问题] R 写入SQL问题
时间Thu Feb 18 22:24:45 2016
- 问题: 当你想要问问题时，请使用这个类别
[问题类型]:
程式谘询(我想用R 做某件事情，但是我不知道要怎麽用R 写出来)
[软体熟悉度]:
请把以下不需要的部份删除
使用者(已经有用R 做过不少作品)
[问题叙述]:
目前 从 A 的 SQL 主机 捞资料 到 linux 上的 R 计算後
欲写入 到 B 的 SQL 主机
遇到问题 写入後乱码 中文的部分
sqlSave(con, data, tablename = "table",rownames=FALSE,append=TRUE)
写入後 情况 http://imgur.com/aXM2V2h
> sessionInfo()
R version 3.2.2 (2015-08-14)
Platform: x86_64-redhat-linux-gnu (64-bit)
Running under: CentOS Linux 7 (Core)
locale:
[1] LC_CTYPE=zh_TW.UTF-8 LC_NUMERIC=C
LC_TIME=zh_TW.UTF-8 LC_COLLATE=zh_TW.UTF-8 LC_MONETARY=zh_TW.UTF-8
[6] LC_MESSAGES=zh_TW.UTF-8 LC_PAPER=zh_TW.UTF-8 LC_NAME=C
LC_ADDRESS=C LC_TELEPHONE=C
[11] LC_MEASUREMENT=zh_TW.UTF-8 LC_IDENTIFICATION=C
attached base packages:
[1] stats graphics grDevices utils datasets methods base
other attached packages:
[1] RMySQL_0.10.6 DBI_0.3.1 RODBC_1.3-12
loaded via a namespace (and not attached):
[1] tools_3.2.2
补充
然後我试着 在我 WIN 机器上 捞A 计算後 写入B 是正常可以的
win
> sessionInfo()
R version 3.2.1 (2015-06-18)
Platform: i386-w64-mingw32/i386 (32-bit)
Running under: Windows 7 x64 (build 7601) Service Pack 1
locale:
[1] LC_COLLATE=Chinese (Traditional)_Taiwan.950 LC_CTYPE=Chinese
(Traditional)_Taiwan.950
[3] LC_MONETARY=Chinese (Traditional)_Taiwan.950 LC_NUMERIC=C
[5] LC_TIME=Chinese (Traditional)_Taiwan.950
attached base packages:
[1] stats graphics grDevices utils datasets methods base
other attached packages:
[1] RMySQL_0.10.6 DBI_0.3.1 RODBC_1.3-12
loaded via a namespace (and not attached):
[1] tools_3.2.1
[程式范例]:
[环境叙述]:
R version 3.2.2 (2015-08-14)
Platform: x86_64-redhat-linux-gnu (64-bit)
Running under: CentOS Linux 7 (Core)
locale:
[1] LC_CTYPE=zh_TW.UTF-8 LC_NUMERIC=C
LC_TIME=zh_TW.UTF-8 LC_COLLATE=zh_TW.UTF-8 LC_MONETARY=zh_TW.UTF-8
[6] LC_MESSAGES=zh_TW.UTF-8 LC_PAPER=zh_TW.UTF-8 LC_NAME=C
LC_ADDRESS=C LC_TELEPHONE=C
[11] LC_MEASUREMENT=zh_TW.UTF-8 LC_IDENTIFICATION=C
attached base packages:
[1] stats graphics grDevices utils datasets methods base
other attached packages:
[1] RMySQL_0.10.6 DBI_0.3.1 RODBC_1.3-12
loaded via a namespace (and not attached):
[1] tools_3.2.2
[关键字]:
RODBC
SQL
编码
选择性，也许未来有用
--
--
※ 发信站: 批踢踢实业坊(ptt.cc), 来自: 111.241.19.39
※ 文章网址: https://webptt.com/cn.aspx?n=bbs/R_Language/M.1455805489.A.CFB.html
1F：→ Wush978: UTF-8 v.s. BIG-5? 02/18 22:26
2F：→ psinqoo: YES 02/19 08:36
3F：→ Wush978: 那你可以试着查该资料库有没有设定encoding的地方看看 02/19 22:10