之前把中文数据添加进Oracle数据库后,查询出现乱码,查了查是字符集不同导致的,于是修改了Oracle字符集AL32UTF8,它支持所有语言,也支持中文的。
此处修改为AL32UTF8
sql> conn / as sysdba;
sql> shutdown immediate;
sql> startup mount;
sql> alter system enable restricted session;
sql> alter system set job_queue_processes=0;
sql> alter system set aq_tm_processes=0;
sql> alter database open;
sql> alter database character set internal_use AL32UTF8;
sql> shutdown immediate;
sql> startup;
此处修改为AL32UTF8