oracle数据库的字符集查询
-------------------------------------------------------
1、oracle server 端 字符集查询
select userenv('language') from dual
select * from v$nls_parameters;
其中NLS_CHARACTERSET 为server端字符集
NLS_LANGUAGE 为 server端字符显示形式
2、查询oracle client端的字符集
$echo $NLS_LANG
3、server端字符集修改
sqlplus / as sysdba
shutdown immediate;
startup mount;
ALTER SESSION SET SQL_TRACE=TRUE;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
-------------------------------------------------------
1、oracle server 端 字符集查询
select userenv('language') from dual
select * from v$nls_parameters;
其中NLS_CHARACTERSET 为server端字符集
NLS_LANGUAGE 为 server端字符显示形式
2、查询oracle client端的字符集
$echo $NLS_LANG
3、server端字符集修改
sqlplus / as sysdba
shutdown immediate;
startup mount;
ALTER SESSION SET SQL_TRACE=TRUE;
ALTER SYSTEM ENABLE RESTRICTED SESSION;