Modifying the Oracle Character set

Recently in the project encountered in the Oracle database detected that the characters are all garbled, because the character set is inconsistent, so to modify their own Oracle character set, the following steps:

Using Oracle's SQL Plus Command window to change

In Sql*plus, log on as DBA

Conn User name as Sysdba

Then execute the following command



>shutdown immediate; (the database was stopped)

>startup Mount; (Re-open the database to change the situation)

>alter system enable restricted session;

>alter system set job_queue_processes=0;

>alter system set aq_tm_processes=0;

>alter database open;

>alter database character set UTF8;

Performing the above line may cause an error:
ALTER DATABASE CHARACTER SET zhs16gbk ERROR at line 1:

Ora-12712:new character set must be a superset of the old character set
Workaround:
>alter DATABASE Character set Internal_use UTF8;

>shutdown immediate;

>startup; (Re-open normal Oracle)

Finally found in the registry:
HKEY_LOCAL_MACHINE, software->oracle->key_xe-> the right form, click Nls_lang, write the target character set in the "American_america. UTF8 "->ok->close REGISTRY
Restart Monitoring and service

Modifying the Oracle Character set