首页 > 代码库 > oracle编码转换:AL32UTF8->ZHS16GBK

oracle编码转换:AL32UTF8->ZHS16GBK

 

--修改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; --zhs16gbk         SQL>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; --zhs16gbk         shutdown immediate;    startup;  

  

oracle编码转换:AL32UTF8->ZHS16GBK