首先查询数据库编码:
select userenv('language') from dual;
得到:
【更改编码】
--修改Oracle数据库字符集为utf-8: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 internal_use utf8; --zhs16gbkSQL>shutdown immediate;SQL>startup;
再次执行:
-- 下面直接复制:
--修改Oracle数据库字符集为utf-8:conn / 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 utf8; --zhs16gbkshutdown immediate;startup;