You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I am trying to extract data from Mysql database using RMysql packages in R. The data gets imported into r with the changed encoding format where in "Córdoba" in UTF-8 gets changed to "Córdoba".
I have tried to set names as utf8 as per the suggestion but with no luck.
Here is the command for it:
dbGetQuery(mydb,"set names utf8")
My Session info
sessionInfo()
R version 3.4.0 (2017-04-21)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows 7 x64 (build 7601) Service Pack 1
I am trying to extract data from Mysql database using RMysql packages in R. The data gets imported into r with the changed encoding format where in "Córdoba" in UTF-8 gets changed to "Córdoba".
I have tried to set names as utf8 as per the suggestion but with no luck.
Here is the command for it:
My Session info
It looks some fundamental thing is missing from my end. Looking for a resolution from someone. Kindly help please.
The text was updated successfully, but these errors were encountered: