ORACLE 修改数据库编码

select userenv(‘language’) from dual;

select * from nls_database_parameters where parameter ='NLS_CHARACTERSET';
修改字符集编码(这会对数据库的数据有直接的影响,谨慎操作):

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 AL32UTF8;
shutdown immediate;
startup;