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也能正常显示了。