linux 下oracle 中文乱码、编码设置

查看oracle服务器端字符集

 

select * from nls_database_parameters

 

 

客户端字符集

 

select * from nls_instance_parameters

 修改oracle10g字符集，在pl/sql下

 

connect system 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 ;

 导入oracle10g中，注释变乱码 vi /etc/profile 添加环境变量

 

export NLS_LANG=American_America.ZHS16GBK