查看当前字符集:
修改oracle字符集:
据说一般zhs16gbk比较好。
select userenv('language') from dual;
修改oracle字符集:
connect system/oracle10g as sysdba;
shutdown immediate;
startup mount;
alter system enable restricted session ;
alter system set JOB_QUEUE_PROCESSES=0;
alter system set AQ_TM_PROCESSES=0;
alter database open;
alter database character set internal_use zhs16gbk;
shutdown immediate;
startup;
据说一般zhs16gbk比较好。