查看Oracle数据库字符集（CharSet）- 编码

一、查看数据库服务器字符集
SQL>select value from nls_database_parameters where PARAMETER=‘NLS_CHARACTERSET’;

二、查看客户端字符集
SQL>select * from nls_instance_parameters;

三、查看会话字符集
SQL>select * from nls_session_parameters;

四、修改数据库服务器字符集
SQL>startup nomount;
SQL>alter database mount exclusive;
SQL>alter system enable restricted session;
SQL>alter system set job_queue_process=0;
SQL>alter database open;
SQL>alter database character set zhs16gbk;