Martin's Blog

For an application that I'm building, I needed to synchronise my Domino Data with Oracle. Then when the data is in Oracle I can access the data easely with Cognos for the creation of reports. There was only one thing that made me nuts, the diacritics where not correct. I looked at several ini settings and forums but I couldn't find what the problem was. Then a Oracle colleage came up with this.

Have a closer look to the Oracle Client that is installed on the (Windows) Server where also my Domino Server runs. If you click on the sever on "My Computer" whith your right mousebutton and then you go to "Properties" then to the tab "Advanced" and then to "Enviroment Variables" you will see this:

Here I had to add: NLS_LANG with the value AMERICAN_AMERICA.UTF8 to the System variables.
Then I rebooted the (Windows) Server and YES! It worked!
The Diacritic are now correct!