如何查看及修改oracle编码格式方法

  select userenv(‘language‘) from dual;

 

  SIMPLIFIED CHINESE_CHINA.AL32UTF8

  sql> conn / as sysdba;

  sql> shutdown immediate;

  database dismounted.

  sql> startup mount;

  total system global area  135337420 bytes

  fixed size                          452044 bytes

  variable size                     109051904 bytes

  database buffers              25165824 bytes

  redo buffers                      667648 bytes

  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

  sql> shutdown immediate;

  sql> startup;

郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。