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;
