(转)改Oracle字符集到utf-8,可以入中文,日文,其他字符

先check下現在oracle字符集

Check nls_parameter:

Select * from v$nls_parameters;

check nls_database_parameters

Select * fron nls_database_parameters;

1-改 Regedit

Start -> Run -> Rededit <-|

Under registry Editor - > HKEY_LOCAL_MACHINE -> SOFTWARE ->ORACLE->KEY_XE->RIGHT WINDOW DOUBLE CLICK NLS_LANG -> CHANGE VALUE TO "AMERICAN_AMERICA.UTF8" ->OK ->CLOSE REGISTRY

 

2-改database character

Start -> Run -> cmd<-|

> connect sqlplus "用戶/pass as sysdba" (sysdba-oracle database name)

>shutdown immediate; (吧database停了)

>startup mount; (吧database重開去可更改情況)

>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 utf8;     OR >alter database character internal_use set utf8;

OR  alter database character set internal_use utf8;

>shutdown immediate;

>startup; (重開正常oracle)