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?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Alexander Eßer [Alex140181]Software DeveloperCommented:
I think this one hits the nail:

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.
 * 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
 * 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_imtechAuthor Commented:
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.
jim_imtechAuthor Commented:
I got this working after changing PROPS$ for LANG, TERRITORY and CHARACTERSET

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jim_imtechAuthor Commented:
You have to change this properties for the database to except the characters
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.