linux下oralce更改字符集,发现乱码问题,一查发现所装的oracle不是中文字符集,更改之。。。
查询当前的字符集
Sql代码
select userenv('language') from dual;
修改为zhs16gbk字符集
Sql代码
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 zhs16gbk;
shutdown immediate;
startup;