Oracle修改字符集记录

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 WE8MSWIN1252;

alter system set nls_language='AMERICAN' scope = spfile;
alter system set nls_territory='AMERICA' scope=spfile;

shutdown immediate;
startup; 

select userenv('language') from dual;

select * from nls_database_parameters  where parameter  in('NLS_LANGUAGE','NLS_TERRITORY','NLS_CHARACTERSET');
select * from v$nls_parameters where parameter in ('NLS_LANGUAGE','NLS_TERRITORY','NLS_CHARACTERSET');

export NLS_LANG='AMERICAN_AMERICA.WE8MSWIN1252'

create table o_3222(i varchar(128));
insert into o_3222 values ('的是不了人我在有他这为之大来以个中上们');
select i, rawtohex(i) from o_3222;