The database character set (AL32UTF8) and the client character set (2%) are different

When we log in to the Oracle database, we encounter the message: "The database Character set (AL32UTF8) and the client character set (2%) are different."

This is due to inconsistent character set between the database server and client, the server character set and the client character set are the same to correctly parse out the contents of the database. The two are equivalent to a code, a decoding, must be the same to decode the correct

Solution:

1. Open the registry, ' Start '-' run ' input ' regedit '-OK.

　　

2. Find HKEY_LOCAL_MACHINE\Software

3. Find \wow6432node

　　

4, find \oracle\key_oraclient11g_home1.

　　

5. Find the Nls_lang key and modify the Nls_lang

　　

6, his original value is: Simplified Chinese_china. ZHS16GBK, with simplified Chinese_china. Al32utf8 Replace the original value

　　

7, re-open plsql, login, just fine.

The database character set (AL32UTF8) and the client character set (2%) are different