Mr Sankaran, It may be your character set that's wrong or check your MySQL configuration. On Dec 21, 2011 12:31 AM, "Raji" <raji.sanka...@gmail.com> wrote:
> Hi All, > > We are using the following dataset which contains UTF-8 characters and is > stored in a MySQL database. When we use > RODBC and read the data, the characters are read correctly.But when we read > using RJDBC ,the characters are read like > ãââ¬Å¡Ã«Ã£ââ¬Å¡Ã¿Ã£ââ¬Å¡Ã«Ã£Ãâà 1 > > Can you please let me know how we can read the UTF-8 characters as it is > done by RODBC. > > ID code Outlook Temperature Humidity Windy Play > a Sunny Hot High FALSE ãâ«ãâ¿ãâ«ãÆÅ 1 > b Sunny Hot High TRUE ãâ«ãâ¿ãâ«ãÆÅ 2 > c Overcast Hot High FALSE ãâ«ãâ¿ãâ«ãÆÅ 3 > d Rainy Mild High FALSE ãâ«ãâ¿ãâ«ãÆÅ 1 > e Rainy Cool Normal FALSE ãâ«ãâ¿ãâ«ãÆÅ 2 > f Rainy Cool Normal TRUE ãâ«ãâ¿ãâ«ãÆÅ 2 > g Overcast Cool Normal TRUE ãâ«ãâ¿ãâ«ãÆÅ 1 > h Sunny Mild High FALSE ãâ«ãâ¿ãâ«ãÆÅ 3 > i Sunny Cool Normal FALSE ãâ«ãâ¿ãâ«ãÆÅ 3 > j Rainy Mild Normal FALSE ãâ«ãâ¿ãâ«ãÆÅ 3 > k Sunny Mild Normal TRUE ãâ«ãâ¿ãâ«ãÆÅ 2 > l Overcast Mild High TRUE ãâ«ãâ¿ãâ«ãÆÅ 2 > m Overcast Hot Normal FALSE ãâ«ãâ¿ãâ«ãÆÅ 3 > n Rainy Mild High TRUE ãâ«ãâ¿ãâ«ãÆÅ 2 > m Overcast MILD Normal FALSE ãâ«ãâ¿ãâ«ãÆÅ 1 > > > Thanks, > Raji > > -- > View this message in context: > http://r.789695.n4.nabble.com/Reg-Using-RJDBC-to-read-UTF-8-characterrs-tp4220650p4220650.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > [[alternative HTML version deleted]]
______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.