Tuning Oracle Database encoding

The newly installed database may need to adjust the Oracle database encoding, otherwise importing data may be an error.

oracle11g changing the character set Al32utf8 to ZHS16GBK

SQL code

Database Character Set (Al32utf8) and Client character set (ZHS16GBK) are different.

Character set conversion may cause unexpected results.

Note:you can set the client character set through the Nls_lang environment variable or the Nls_lang registry key in

Hkey_local_machine\software\oracle\key_oradb11g_home1.

Simplified Chinese_china. ZHS16GBK contains American_america. Al32utf8.

-This is a problem, not a change to the client character set. The character set of the database to be changed.

Sql>select userenv (' language ') from dual; viewing native character Sets

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 ZHS16GBK;

Ora-12712:new character set must be a superset of the old character set

--Prompt Our character set: The new character set must be a superset of the old character set, and we can skip over the superset check to make the change:

Sql> ALTER DATABASE Character set Internal_use ZHS16GBK;

--we see that this process is identical to the internal procedure of the ALTER DATABASE CHARACTER set operation, which means that the help provided by Internal_use is to get the Oracle database to bypass the checksum of the subset and the superset.

Sql> select * from V$nls_parameters;

sql> shutdown immediate;

Sql> Startup

Sql> select * from V$nls_parameters;

--When installing oracle11g later, remember to choose a custom installation, the character set of things in advance.

Database query garbled:

[Email protected]:~>cat. Profile

Export nls_lang= ' American_america. ZHS16GBK '

#SLES默认安装时: Add

vim/etc/profile.d/oracle.sh

Export nls_lang= ' American_america. ZHS16GBK '

This article is from the "Han Lei" blog, make sure to keep this source http://deararvin.blog.51cto.com/11158301/1739636

Tuning Oracle Database encoding