Character set (windows export from oracle database)
Posted on 2014-07-15
I have Oracle 10gR2 database with nls settings:
I want to export data to file on windows server 2008 R2 with region and language set to Slovenian. When exporting, special characters like "š" becomes "(c)", and "č" IS "č".
When setting the registry key NLS_LANG and NLS_CHARACTERSET to SLOVENIAN_SLOVENIA.WE8MSWIN1252 then "š" IS "š", but "č" becomes "c".
I have also changed the settings on the ODBC driver to use server settings or even regional client settings, still the output is no different than before.
Does anyone have an idea how to setup these settings that the export would contain characters like š,č,ž ?