Change NLS Character set parameters on Oracle 11g XE

oracle, oracle-apex, oracle-xe, oracle11g, sql

Solution

This worked for me where an application was checking for `UTF8 rather than AL32UTF8` .

SQL> shutdown immediate;

SQL> startup restrict

SQL> select name from v$database;

SQL> ALTER DATABASE CHARACTER SET INTERNAL_USE UTF8 ;

SQL> select value from NLS_DATABASE_PARAMETERS 
     where parameter=’NLS_CHARACTERSET’;

SQL> shutdown immediate;

SQL> startup

Problem

I am using Oracle 11g Express Edition. Currently when I check NLS character set parameter using `SELECT * FROM nls_database_parameters;` it gives the default values: ``` NLS_CHARACTERSET: AL32UTF8 NLS_NCHAR_CHARACTERSET: AL16UTF16 ``` I want to set both these parameters to UTF8. How can I do so? I have just installed Oracle 11g XE, so there is not data except those required by Oracle itself.

Original source