'In R, while using sqlSave to save data in Oracle, special character is being distorted
This is my data SÃO which is being read by R properly.
However, while saving it in Oracle, it is being stored as SÃO.
I have set both DB and OS where R hosted to UTF-8.
Before calling sqlSave executing Sys.setenv(NLS_LANG = "AMERICAN_AMERICA.AL32UTF8") explicitly to set the encoding once again but no luck.
Sys.setenv(NLS_LANG = "AMERICAN_AMERICA.AL32UTF8")
lconn <- odbcConnect("MYDB",uid="*****",pwd="*****",believeNRows=FALSE);
aout<-sqlSave(lconn,txtdframe,tablename=datatblnm,append=TRUE,fast=FALSE,safer=TRUE,rownames=FALSE,nastring=NULL,varTypes=varTypes,verbose=FALSE);
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
