Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Character set (windows export from oracle database)

Posted on 2014-07-15
Medium Priority
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 43

Accepted Solution

pcelba earned 2000 total points
ID: 40196541
You should set NLS_CHARACTERSET to WE8MSWIN1250 or EE8MSWIN1250 because Slovenian language uses Eastern European Code Page 1250.

More info: http://www.orafaq.com/wiki/NLS_LANG

Author Comment

ID: 40196687
thx !!

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Understanding the various editions available is vital when you decide to purchase Windows Server 2012. You need to have a basic understanding of the features and limitations in each edition in order to make a well-informed decision that best suits …
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…
Suggested Courses

571 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