Character set (windows export from oracle database)

Posted on 2014-07-15
Last Modified: 2014-07-15

I have Oracle 10gR2 database with nls settings:
NLS_LANGUAGE                   AMERICAN
NLS_TERRITORY                  AMERICA
NLS_CHARACTERSET               EE8ISO8859P2

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 š,č,ž ?
Question by:SimpleJ
    LVL 41

    Accepted Solution

    You should set NLS_CHARACTERSET to WE8MSWIN1250 or EE8MSWIN1250 because Slovenian language uses Eastern European Code Page 1250.

    More info:
    LVL 1

    Author Comment

    thx !!

    Featured Post

    Are end users causing IT problems again?

    You’ve taken the time to design and update all your end user’s email signatures, only to find out they’re messing up the HTML, changing the font and ruining the imagery. What can you do to prevent this? Find out how you can save your signatures from end users today.

    Join & Write a Comment

    Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
    The use of stolen credentials is a hot commodity this year allowing threat actors to move laterally within the network in order to avoid breach detection.
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
    With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now