Oracle modifies the default character encoding

To view the Oracle database character set:

Sql> Select Userenv (' language ') from dual;

USERENV (' LANGUAGE ')
--------------------------------------------------------------------------------
American_america. we8mswin1252

sql> shutdown immediate;

sql> startup Mount;

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;

Sql> Select Userenv (' language ') from dual;

USERENV (' LANGUAGE ')
----------------------------------------------------
American_america. Al32utf8

Export nls_lang="simplified Chinese_china. Al32utf8 " add Oracle User variables to

This article from "King Good Handsome" blog, reproduced please contact the author!

Oracle modifies the default character encoding