From the latest docs:
AL16UTF16 => valid for NCHAR columns (CSID=2000)
UTF8 => valid for NCHAR columns (CSID=871), deprecated
AL32UTF8 => valid for NCHAR and CHAR columns (CSID=873)
-and-
Both UTF8 and AL32UTF32 can be used in NLS_LANG and NLS_NCHAR. For
example:
NLS_LANG=AMERICAN_AMERICA.UTF8
NLS_LANG=AMERICAN_AMERICA.AL32UTF8
NLS_NCHAR=UTF8
NLS_NCHAR=AL32UTF8
Where does this information come from? Our db-admins are telling me that
in our current installation (10.1.0.3), AL32UTF8 cannot be used for the
national language character set, just the database character set. Could
someone please provide a pointer to the source of this information.
