SELECT USERENV('LANGUAGE') FROM DUAL;
-- 例:SIMPLIFIED CHINESE_CHINA.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
警告:INTERNAL_USE 參數跳過超集檢查,若目標字符集非源字符集超集,可能導致資料損壞。生產環境建議用 DMU (Database Migration Assistant for Unicode) 正規遷移。
編輯 $HOME/.bash_profile(或 Windows 環境變數):
export NLS_LANG="SIMPLIFIED CHINESE_CHINA.AL32UTF8"
三部份:語言_地區.字符集,三者必須一致,否則產生亂碼。
SELECT * FROM NLS_SESSION_PARAMETERS WHERE PARAMETER IN ('NLS_LANGUAGE','NLS_TERRITORY','NLS_CHARACTERSET');