修改ORACLE数据库字符集

$ sys/xy123456 as sysdba                                       /*用户sys，密码xy123456*/

SQL>shutdown immediate;                                  /*关闭数据库，以便重新mount登陆*/
SQL> startup mount;
SQL> alter system enable restricted session;
SQL> alter system set job_queue_processes=0;
SQL> alter database open;
SQL> alter database character set internal_use UTF8;
SQL> shutdown immediate;
SQL> startup


如果在window下用plsql连接后需要修改注册表的内容(也可以不修改,只不过会有一个错误提示,其实不影响)
注册表:HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/KEY_OraDb10g_home1中的NLS_LANG值改为:如果SIMPLIFIED CHINESE_CHINA.ZHS16GBK改为SIMPLIFIED CHINESE_CHINA.utf8