修改oracle数据库的编码为utf8

1、打开DOS窗口 

2、sql / as sysdba

3、shutdown immediate;

4、startup mount;

5、alter session set sql_trace=ture;

6、alter system enable restricted session;

7、alter system set job_queue_processes=0;

8、alter system set aq_tm_processes=0;

9、alter database open;

10、alter database character set internal_use utf8;

(11、alter session set sql_trace=false;

12、shutdown immediate;;

13、startup;)

或者

(11、update props$ set VALUE$='UTF8' where NAME='NLS_NCHAR_CHARACTERSET';)