查看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