[問題] R 寫入SQL問題

看板R_Language作者psinqoo (零度空間)時間9年前 (2016/02/18 22:24)推噓0(0推 0噓 3→)

留言3則, 2人參與討論串1/1

- 問題: 當你想要問問題時，請使用這個類別 [問題類型]: 程式諮詢(我想用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://www.ptt.cc/bbs/R_Language/M.1455805489.A.CFB.html