使用RMySQL进行UTF8编码(UTF8 encoding using RMySQL)

 我正在尝试从包含一些字符串的mysql数据库中查询数据。 对于连接和数据检索，我在R中使用RMySQL，它工作正常。 除了一件事：我正在检索的字符串似乎不在utf8中。 但我需要这个，因为我在这些字符串中有一些德语“Umlaute”。 当我问数据库时，它是由它编码的 
 
dbGetQuery(db, "SHOW VARIABLES LIKE 'character_set_%';")
 
 我得到了理想的答案： 
 
             Variable_name           Value
1   character_set_client             utf8
2   character_set_connection         utf8
3   character_set_database           utf8
4   character_set_filesystem         binary
5    character_set_results           utf8
6     character_set_server           utf8
7     character_set_system           utf8
8       character_sets_dir C:\\Program Files\\MySQL\\MySQL Server 5.7\\share\\charsets\\
 
 但是，例如我收到了 
 
Andreas Wünsche
 
 代替 
 
Andreas Wünsche
 
 希望有人知道如何处理它。 如果需要额外的信息，请问。 我可以提供。 

I am trying to query data from a mysql database, which contains some strings, of course. For the connection and data retrieval I am using RMySQL in R, which works fine. Apart from one thing: the strings I am retrieving seem not to be in utf8. But I need this, because I have some german "Umlaute" in these strings. When I ask teh databse, which are its encoding by 
 
dbGetQuery(db, "SHOW VARIABLES LIKE 'character_set_%';")
 
I get the desired answer:
 
             Variable_name           Value
1   character_set_client             utf8
2   character_set_connection         utf8
3   character_set_database           utf8
4   character_set_filesystem         binary
5    character_set_results           utf8
6     character_set_server           utf8
7     character_set_system           utf8
8       character_sets_dir C:\\Program Files\\MySQL\\MySQL Server 5.7\\share\\charsets\\
 
But e.g. I receive 
 
Andreas Wünsche
 
instead of 
 
Andreas Wünsche
 
Hope that somebody knows how to deal with it. If additonal information is needed, just ask. I can provide it.

原文：https://stackoverflow.com/questions/38347348