Oracle Settings Character Set ____oracle

The Al32utf8 character set is not a (display/input) language character set, is a character set for storage and supports the world's leading language encoding.
Al32utf8 is a superset of ZHS16GBK.


The Nls_lang should be set to the language character set used by the system itself and converted to the database language character set.
1. Export the data from the AL32UTF8 server and set the nls_lang= "American_america" before exporting. ZHS16GBK ".
2. Import the data from the ZHS16GBK server and set the nls_lang= "American_america" before importing. ZHS16GBK ".


View the database character set
Sql> select * from V$nls_parameters;
Sql> Select Userenv (' language ') from dual;


viewing system character Sets
Windows:
CMD-> echo%nls_lang%
Linux:
$ locale


Setting the database Character set
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 ZHS16GBK;
Sql> alter system set Nls_language = ' American ' scope = SPFile;
Sql> alter system set Nls_territory = ' AMERICA ' scope = SPFile;
sql> shutdown immediate;
Sql> startup;


Setting the system Character set
Windows:
My Computer-> Properties-> Advanced-> Environment variables
Nls_lang= "American_america. ZHS16GBK "
Linux:
$ export nls_lang= "American_america. ZHS16GBK "