We help IT Professionals succeed at work.

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

markwall1977 asked
Medium Priority
Last Modified: 2013-11-11
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

Watch Question

Data Architect
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.
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
Top Expert 2008
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.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.