oracle数据库的字符集查询
-------------------------------------------------------
1、oracle server 端 字符集查询
select userenv('language') from dual
select * from v$nls_parameters;
3、server端字符集修改
sqlplus / as sysdba
shutdown immediate;
startup mount;
ALTER SESSION SET SQL_TRACE=TRUE;
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 ZHS16GBK;
提示我们的字符集：新字符集必须为旧字符集的超集，这时我们可以跳过超集的检查做更改：
GBK:
ALTER DATABASE character set INTERNAL_USE ZHS16GBK; 或
UTF8:
ALTER DATABASE character set INTERNAL_USE AL32UTF8;
转播
