MySQL R Encoding Utf8

Hi,

dbGetQuery(t.con, "SET NAMES 'utf8'")
before dbSendQuery(t.con, t.sql)
and fetch()
might work.
http://dev.mysql.com/doc/refman/5.6/en/charset-connection.html

You might alternatively change the default values for these
character_set_* variables in MySQL database.

On 2012/02/09, at 3:24, Henri Mone wrote:

Dear R Users and Experts,

I got a MySQL table with German special characters (umlaute like ?,?,?
etc.) . The MySQL database table is in the UTF8 format, and if I
submit a query over the MySql client the umlaute are displayed
correctly. If I submit the same query via R the umlaute are displayed
wrong. That is a little confusing for me, R as well as the MySQL
support UTF8.
Is there any option which I should use to get the umlaute in R correct?

Thanks,
Henri

t.m <-dbDriver("MySQL")
t.con <- try(dbConnect(t.m))
t.rs <- try(dbSendQuery(t.con, t.sql))
t.data <- fetch(t.rs,-1)
t.data ?# correct would be "?sterreichische Schilling"

?\xd6sterreichische Schilling
?...