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.