Displaying UTF-8 encoded characters in R
<p>I am using the <code>RODBC</code> package to read data from SQL server. R is reading the Chinese characters as "?????" 
I have passed the parameter <code>DBMSencoding = "UTF-8"</code> to the <code>odbcConnect</code> function. </p>

<p>Following is the sample code I am using:</p>

<pre><code>Connection &lt;- odbcConnect("abc", uid = "123", pwd = "123", 
                          DBMSencoding = "UTF-8", readOnlyOptimize=T)

Var1 &lt;- sqlQuery(Connection, query, errors = TRUE, stringsAsFactors=F)
</code></pre>

<p>May be I didn't pass the arguments the way I am supposed to? </p>

<pre><code>sessionInfo()
R version 3.2.3 (2015-12-10)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows 7 x64 (build 7601) Service Pack 1

locale:
[1] LC_COLLATE=English_United States.1252  LC_CTYPE=English_United States.1252    LC_MONETARY=English_United States.1252
[4] LC_NUMERIC=C                           LC_TIME=English_United States.1252    

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base     

other attached packages:
[1] RODBC_1.3-12

loaded via a namespace (and not attached):
[1] tools_3.2.3

odbcGetInfo(mainConnection)
         DBMS_Name               DBMS_Ver        Driver_ODBC_Ver      Data_Source_Name            Driver_Name 
        "Microsoft SQL Server"  "10.50.4000"     "03.52"                                         "SQLSRV32.DLL" 
        Driver_Ver               ODBC_Ver            Server_Name 
      "06.01.7601"           "03.80.0000"            
</code></pre>