'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