Thursday, July 19, 2012

Oracle Characterset.

1. The (ordinary) character set for a database can be determined with:

select value from nls_database_parameters where parameter = 'NLS_CHARACTERSET';
2. The national character set for a database can be determined with:

select value from nls_database_parameters where parameter = 'NLS_NCHAR_CHARACTERSET';