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