[R] RJDBC and Unicode characters on Windows

Joshua Ainsley jainsley at gmail.com
Tue May 19 18:38:39 CEST 2015


Hello,

I am using the RJDBC library to connect to a SQL database and pull out text
that includes Hebrew characters. If I do this on a Mac, the data frames I
construct display the characters properly. If I do it on a Windows PC, then
the characters are converted to strings like this:

<U+05DE><U+05E2><U+05D5><U+05EA> <U+05D7><U+05D8><U+05D9><U+05DD>

I have tried "UTF-8", "UCS-2LE", "UTF-8-BOM", and "UTF-16LE" encodings with
no luck. Any suggestions on getting the data to display properly?

Thanks,
Josh

	[[alternative HTML version deleted]]



More information about the R-help mailing list