Problematic unicode encoding when using RJDBC

Asked May 19 '15 at 15:06

Active May 19 '15 at 15:14

Viewed 283 times

I am pulling data from a SQL table and putting it into a data frame using the RJDBC package in R. The data has Hebrew characters that are not displaying properly and I end up with strings like this:

<U+05D4><U+05D0><U+05DD> <U+05D0><U+05EA><U+05D4>

This only occurs when I am using a Windows machine using RJDBC in R. If I use Microsoft SQL Server or a Mac, I have no issues.

I can use the function found here to solve the problem, but I'd prefer something that allows me to read the data correctly.

Any suggestions?

edited May 23 '17 at 11:51

Community

asked May 19 '15 at 15:06

JoshuaA

Have you tried playing with `options("encoding")`? – Roman Luštrik May 19 '15 at 15:09
Yes. I can run `options(encoding = "UTF-8")` and it still has the same issues. – JoshuaA May 19 '15 at 15:14
Have you tried encodings other than UTF-8? What is the encoding in the data base? – Roman Luštrik May 19 '15 at 15:26
The database is UNICODE. I have tried "UCS-2LE", "UTF-8-BOM", and "UTF-16LE" but they don't fix the problem. – JoshuaA May 19 '15 at 16:18

Problematic unicode encoding when using RJDBC

0 Answers0