Best Charset NLS_LANG for new oracle 11G data warehouse, FTSE100 UK based company

What would the best character set be for a new data warehouse in Oracle 11G.

The considerations are:
-Application supported charactersets (for example Cognos, Business Objects will report on the data)
-Data is being migrated from DB2 using Informatica
-Company is very large UK based with international operations, future considerations must be taken into account (but Chinese support is ruled out / not required).
- Want to avoid the scenario of changing NLS_LANG on the database later in the development cycle

I am suggesting UTF8 and setting a standard of Unicode character sets cross enterprise. What limitations (if any will this impose). Is it better to go for a more local Western Europe NLS_LANG parameter ?


Open in new window

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.

SujithData ArchitectCommented:
NLS_LANG - is not an attribute of your database. It is a client side environment setting that tells Oracle about the client side character set info.

If you are planning to support multiple regions, the safest would be to have your database in UTF-8 character set.

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
unless you have some special symbols on your db2 side, you won't have problems using what ever character set you want
informatica should be able to handle the conversions
AL32UTF8 is the most universal Character set of Oracle 11g (up to 4 bytes UTF8 encoding).
Choose it wnen creating a new Data base using DBCA utility of Oracle.
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.