Oracle修改默認字符編碼

    --查看Oracle數(shù)據(jù)庫字符集：
    Sql代碼
    select userenv('language') from dual;
    查詢結果：
    SIMPLIFIED CHINESE_CHINA.AL32UTF8
    --修改oracle數(shù)據(jù)庫字符集：(在SQL Plus中)
    Sql代碼
    sql> conn / as sysdba;
    sql> shutdown immediate;
    database closed.
    database dismounted.
    oracle instance shut down.
    sql> startup mount;
    oracle instance started.
    total system global area 135337420 bytes
    fixed size 452044 bytes
    variable size 109051904 bytes
    database buffers 25165824 bytes
    redo buffers 667648 bytes
    database mounted.
    sql> alter system enable restricted session;
    system altered.
    sql> alter system set job_queue_processes=0;
    system altered.
    sql> alter system set aq_tm_processes=0;
    system altered.
    sql> alter database open;
    database altered.
    sql> alter database character set internal_use AL32UTF8;
    sql> shutdown immediate;
    sql> startup;
    修改oracle用戶的NLS_LANG
    編輯/home/oracle/.bash_profile
    Bash代碼
    export NLS_LANG="SIMPLIFIED CHINESE_CHINA.AL32UTF8"