Setting correct NLS_LANG on Mac for a Oracle database with WE8MSWIN1252

1.1k Views Asked by At

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.

0

There are 0 best solutions below