[R] dbi, rodbc, rmysql, charset problem

2007-02-18 Thread janek0
Dear List In my short life as a beginning R-user i've encountered a following problem that i'm unable to solve myself: I have a database in MySQL containing table and field names as well as some data containing Polish accentuated characters (like ąśęć), utf8-encoded. It works just fine with just

Re: [R] dbi, rodbc, rmysql, charset problem

2007-02-18 Thread Prof Brian Ripley
You seem never to have told R or us what charset these data are in. I think it is likely that they are being transferred in latin2 (like your email), and you are running R in UTF-8 according to Sys.getlocale. So what you need to do is to either 1) Run R in latin2 or 2) use iconv() to