修改Oracle資料庫字符集

檢視當前資料庫字符集

select userenv('language') from dual;

 

USERENV('LANGUAGE')

------------------------------------

SIMPLIFIED CHINESE_CHINA.AL32UTF8

 

修改引數

alter system enable restricted session;

 

更改字符集，並跳過對超集的檢查

alter database character set internal_use zhs16gbk;

 

重啟資料庫

shutdown immediate

startup

 

確認字符集已更改

select userenv('language') from dual;

 

USERENV('LANGUAGE')

--------------------------------------

SIMPLIFIED CHINESE_CHINA.ZHS16GBK