oracle字符集修改

以dba身份登录,详细可查看上一篇文章oracle在docker下的安装配置

命令如下:

 select userenv('language') from dual;  //查看字符集

 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;//改为utf-8
 // alter database character set internal_use zhs16gbk; 改为gbk
 shutdown immediate;
 startup;