Sys.setenv(NLS_LANG="SIMPLIFIED CHINESE_CHINA.AL32UTF8")
library("RODBC")
channel <- odbcConnect("hrmln",uid="username",pwd="password",DBMSencoding = "UTF-8")
mydata <-sqlQuery(channel,'select * from mln_course where rownum <3')
Sys.setenv(NLS_LANG="SIMPLIFIED CHINESE_CHINA.AL32UTF8")
library("RODBC")
channel <- odbcConnect("hrmln",uid="username",pwd="password",DBMSencoding = "UTF-8")
mydata <-sqlQuery(channel,'select * from mln_course where rownum <3')