先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) |