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 ?