Oracle character set settings

April 02, 2012 DB

Here are the queries to view the char and nchar character set settings:

select value from nls_database_parameters where parameter = ‘NLS_CHARACTERSET’;

select value from nls_database_parameters where parameter = ‘NLS_NCHAR_CHARACTERSET’;

These return AL32UTF8 for me, which apparently supersedes UTF8 (which is an older setting in Oracle for an older unicode specification which is missing some XML specific characters).