1、查看oracle服务字符集
select userenv('language') from dual;
2、修改oracle服务器端字符集
在SQL*PLUS 中,以DBA登录
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 utf8;
第 1 行出现错误:
ORA-12712: 新字符集必须为旧字符集的超集
>alter database character set internal_use utf8;
>shutdown immediate;
>startup;