Which character set to use to support Unicode and Japanese Character set?
636221Aug 16 2008 — edited Aug 20 2008Hi,
We have an existing database with the ff details:
Version: 10.2.0.1
NLS_CHARACTERSET: WE8ISO8859P1
NLS_NCHAR_CHARACTERSET: AL16UTF16
We want it to support both unicode and the japanese character set so we may need to change this. my questions are:
1. which new character set will we use both for NLS_CHARACTERSET and NLS_NCHAR_CHARACTERSET?
2. What are the things do we need to watch out for during migration/conversion? (i.e. Data corruption, truncation, etc... if any)