View and modify Oracle encoding format method ____web

--View Oracle database Character set:
SELECT * FROM V$nls_parameters
Select Userenv (' language ') from dual;


Query results:


Simplified Chinese_china. Al32utf8


--Modifying the Oracle Database Character set: (In SQL Plus)


Sql> Conn/as sysdba;


sql> shutdown immediate;


Database closed.


Database dismounted.


Oracle instance shut down.


sql> startup Mount;


Oracle instance started.


Total system global Area 135337420 bytes


Fixed size 452044 bytes


Variable size 109051904 bytes


Database buffers 25165824 bytes


Redo Buffers 667648 bytes


Database mounted.


Sql> alter system enable restricted session;


System altered.


Sql> alter system set job_queue_processes=0;


System altered.


Sql> alter system set aq_tm_processes=0;


System altered.


sql> ALTER DATABASE open;


Database altered.


Sql> ALTER DATABASE character set Internal_use ZHS16GBK;


sql> shutdown immediate;


Sql> startup;