转自:http://hi.baidu.com/ideas/item/f5bcc475e727a8570d0a078f
查看 Oracle11g 的字符集:
1、 查看全部字符集: select name, value$ from props$ where name like '%NLS%';
2、查看服务端的字符集: select userenv('language') from dual;
HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/KEY_OraDb11g_home1/ 中右边框中的 NLS_LANG 键所对应的值为即当前 Oracle 客户端使用的字符集,如 SIMPLIFIED CHINESE_CHINA.ZHS16GBK,再如:american_america.al32utf8
3、查看服务端字符集: SQL> select * from nls_database_parameters;
4、查看客户端字符集: SQL> select * from nls_instance_parameters;
5、查看 session 字符集: SQL> select * from nls_session_parameters;
6、修改字符集:
SQL> conn / 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 ZHS16GBK;
SQL> alter shutdown immedite;
SQL> startup;