asked on

Localization in Oracle

I am trying to run my application in Polish lang. The front end is already converted, I am wondering what all should I change at Oracle end (backend) to convert my lookup tables etc? Should I change the NLS parameters in Oracle? I think I would still want my ORA messages to be in English. Any suggestions?

Alex [***Alex140181***]

I think this one hits the nail:
http://oradbastuff.blogspot.de/2010/10/how-to-change-language-of-database.html

look at/for the chapter "I don't want any other language than English for the messages.":

The solution is to only install the *us.msb ("English") files on ALL clients and servers.
This can be done at installation time by deselecting all other languages or to change on the installation media in the \install\oraparm.ini file the NLS_ENABLED=TRUE parameter to NLS_ENABLED=FALSE.
With this set to FALSE only US (English) files will be installed and (on windows) the NLS_LANG added to the registry will also default to AMERICAN_AMERICA instead of the <Language>_<territory> who match the LOCALE of the windows installation.

For an existing system one can

* de-install the software and the re-install it choosing the required "Product languages"

note that it's currently not possible to "remove" languages using the Universal installer without de-installation and re-installation.

OR
* remove all the non *us.msb (and *us.msg if they exist) files but be carefull to not remove accidentially *us.msb files and do not delete the *.msg file under $ORACLE_HOME/owb
OR
* install the same Oracle version and platform (!!!) on an other system / Oracle_home making sure only "English" is installed
* delete in the current home all *.msg and *.msb files
* copy all *.msg and *.msb files from the new installation to the same location in the original home.

jim_imtech

ASKER

My main task is to get my lookup tables updated. I have installed Oracle by selecting Polish in the wizard and my NLS points to Polish as well.

I now want to get my data in tables but as soon as I commit, the extra characters that polish lang have disappear from the table.

ASKER CERTIFIED SOLUTION

jim_imtech

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jim_imtech

ASKER

You have to change this properties for the database to except the characters