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.sankaran@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]]

