Oracle 修改字符集

oracle安装的时候，根据安装推荐,选了字符集：AL32UTF8，

之后安装了PLSQL Developer，打开就提示以下信息：

    Database character set (AL32UTF8) and Client character set (ZHS16GBK) are different. Character set conversion may cause unexpected results.

    Note: you can set the client character set through the NLS_LANG environment variable or the NLS_LANG registry key in HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME0.

——服务端编码与客户端编码不一致，找到一下方法，总结一下，在此分享！

查看oracle服务端编码：

    select userenv('language') from dual;

    select * from sys.nls_database_parameters;

查看client编码：

    select * from sys.nls_session_parameters;

一、修改客户端编码：

运行-->regedit，进入注册表，

找到 HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/KEY_OraDb10g_home1 的变量NLS_LANG的值

     SIMPLIFIED CHINESE_CHINA.ZHS16GBK

改成其他字符集的值

     SIMPLIFIED CHINESE_CHINA.AL32UTF8

二、修改服务端编码：

    Oracle 10g,修改可以采用下面的方法

  sql>connect system as sysdba ;

  sql>shutdown immediate ;

  sql>startup mount ;

  sql>alter system enable restricted session ;

  sql>alter system set JOB_QUEUE_PROCESSES=0;

  sql>alter system set AQ_TM_PROCESSES=0;

  sql>alter database open ;

  sql>alter database character set internal_use ZHS16GBK ;

  sql>shutdown immediate ;

  sql>startup ;