RMySQL returns messy codes for utf8 texts
<p>SessionInfo is as follows:</p>

<pre><code>R version 3.3.0 (2016-05-03)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows 7 x64 (build 7601) Service Pack 1

locale:
[1] LC_COLLATE=English_Singapore.1252  LC_CTYPE=English_Singapore.1252    LC_MONETARY=English_Singapore.1252 LC_NUMERIC=C                      
[5] LC_TIME=English_Singapore.1252    
</code></pre>

<p>I've already set <code>dbSendQuery(conn, 'SET NAMES utf8')</code>for the initial connection but I still get messy codes for utf texts. I also run <code>SHOW VARIABLES LIKE 'character_set_%'</code>.The results are as follows:
<a href="http://i.stack.imgur.com/Na1AO.png" rel="nofollow">character set for mysql</a>
My version for MySQL is 5.6.17. Anyone can give me some suggestions?</p>