CODEWITHSUNDEEP
roracle-database
nsfy33
nsfy33

Reputation: 115

ROracle is not handling Unicode

I'm using ROracle to query a database with a VARCHAR2 field containing some Unicode characters. When I access the database directly or via RJDBC, I have no issues with pulling this data.

When I pull the data with ROracle, I get ????? instead of the text.

Upvotes: 2

Views: 760

Answers (1)

ibre5041
ibre5041

Reputation: 5298

In OCI you have use env. variable NLS_LANG. For example: NLS_LANG=AMERICAN_AMERICA.AL32UTF8

will make OCI client return all strings returned in UTF8. This should work, if internal string representation in R also uses UTF8. Then ROracle can make simple binary copy from one buffer into another buffer.

Oracle uses question marks in case when it can not translate char into target code page.

Upvotes: 4

Related Questions