Oracle 11g modified Chinese Character Set installed Oracle 11g found that Chinese characters are stored in the database and then changed garbled characters, use the following method to modify the database character set www.2cto.com D: \> sqlplus/nolog SQL * Plus: release 11.2.0.1.0 Production on Wed Nov 7 23:50:56 2012 Copyright (c) 1982,201 0, Oracle. all rights reserved. SQL> conn/as sysdba -- use the SYSDBA account Connected. SQL> startup mount ORA-01081: cannot start already-running ORACLE-shut it down first SQL> shutdown immediate; -- stop Database closed. database dismounted. ORACLE instance shut down. SQL> startup mount -- start the database to the mount state ORACLE instance started. total System Global Area 1686925312 bytes Fixed Size 2176368 bytes Variable Size 989858448 bytes Database Buffers 687865856 bytes Redo Buffers 7024640 bytes Database mounted. SQL> alter session set SQL _trace = true; Session altered. 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> set linesize 120; -- The INTERNAL_USE parameter can ignore the superset check SQL> ALTER DATABASE character set INTERNAL_USE AL32UTF8; -- modify the character set Database altered. SQL> shutdown immediate; -- Shut Down Database closed again. database dismounted. ORACLE instance shut down. SQL> STARTUP -- start ORACLE instance started. total System Global Area 1686925312 bytes Fixed Size 2176368 bytes Variable Size 989858448 bytes Database Buffers 687865856 bytes Redo Buffers 7024640 bytes Database mounted. database opened. SQL> select * from v $ nls_parameters where parameter = 'nls _ CHARACTERSET '; PARAMETER parameter VALUE limit NLS_CHARACTERSET AL32UTF8 SQL>