0

I'm having issues importing norwegian characters like æ, ø, and å from an Oracle database using ROracle. I've previously posted a question without finding an answer.

However, I think there might be a solution in the answer to this question, where he writes:

However, i added the environment variable "NLS_LANG" and the corresponding langauge code to my operating system which fixed the issue

What would be the correct way of doing this? The Oracle database I´m trying to connect to has NLS_CHARACTERSET WE8MSWIN1252, what would the corresponding settings be on a Mac? I've tried setting the locale in terminal with export LC_ALL=UTF-8 in terminal, but with no luck.

Thomas Tallaksen
  • 97
  • 12
  • You must set your `NLS_LANG` variable according to character set of your terminal, i.e. if you set `LC_ALL=UTF-8` then your `NLS_LANG` must be `.AL32UTF8`, see https://stackoverflow.com/questions/33783902/odbcconnection-returning-chinese-characters-as/33790600#33790600 – Wernfried Domscheit Sep 20 '18 at 08:56
  • That fixed it, thanks! – Thomas Tallaksen Sep 20 '18 at 15:07

0 Answers0