R help - Dec 2011 - Reg : Using RJDBC to read UTF-8 characterrs

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.

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]]