How to change database character set :

Hello Everyone,

Today i came accross one warning (i.e change your character set to AL32UTF8) while running RCU for SOA metadata repository.

I have serached it on web and i found one solution for the same, as i am doing R & D test so i tried on that database,

And it works for me,


This article gives a overview of methods to change the database character set step by step :

Step 1. Check NLS_CHARACTERSET

Connect to user SYS or SYSTEM

SELECT * FROM V$NLS_PARAMETERS WHERE PARAMETER = 'NLS_CHARACTERSET';

Parameter Value
NLS_CHARACTERSET TH8TISASCII

If you want to change NLS_CHARACTERSET from TH8TISASCII to AL32UTF8,

Step 2. Connect to user SYS

Step 3. Update value

> UPDATE PROPS$ SET VALUE$ = 'AL32UTF8' WHERE NAME = 'NLS_CHARACTERSET';

> COMMIT;

Step 4. Restart database

> SHUTDOWN IMMEDIATE;

> STARTUP;

Step 5. Check NLS_CHARACTERSET

Connect to user SYS or SYSTEM

> SELECT * FROM V$NLS_PARAMETERS WHERE PARAMETER = 'NLS_CHARACTERSET';

Parameter Value
NLS_CHARACTERSET AL32UTF8

This works me fine for me, any suggestion on the same are welcome..

Waiting for your suggestion on the same.


Thank you

Regards,
Ajinkya Vichare