Oracle modifies the default character encoding

Oracle modifies the default character encoding

-- View the Oracle database character set:

SQL code

Select userenv ('language') from dual;

Query results:

SIMPLIFIED CHINESE_CHINA.AL32UTF8

-- Modify the character set of the oracle database: (in SQL Plus)

SQL code

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;

Modify the NLS_LANG of an oracle user

Edit/home/oracle/. bash_profile

Bash code

Export NLS_LANG = "SIMPLIFIED CHINESE_CHINA.AL32UTF8"