oracle中文乱码

oracle的中文注释乱码了

 

查看oracle字符集的sql

select userenv('language') from dual;

 

修改oracle10G的字符集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 ;

老版本的可以参考（这个没实践）

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 ZHS16GBK; 
ALTER DATABASE national CHARACTER SET ZHS16GBK; 
SHUTDOWN IMMEDIATE; 
STARTUP; 

 UTF8是AL32UTF8。

oracle .bash_profile中加入export NLS_LANG=AMERICAN_AMERICA.AL32UTF8。

 

在toad的机器上

把NLS_LANG 的值设为AMERICAN_AMERICA.ZHS16GBK，没有就添加。这样toad也能正常显示了。