Oracle Server and client character set different result in Chinese garbled solution

1. Description of the problem

When you log in with PL/SQL, you will be prompted that the " database character set (ZHS16GBK) and client character set (2%) are different, character set conversions can cause unpredictable consequences ", the specific problem is Chinese garbled, such as

2. Problem analysis

Whatever your database character set in the error message is due to the inconsistency between the database server and your client character set, you can fix the problem by changing the client character set to match the service-side character set.

3. Problem resolution Steps

3.1 Viewing the service-side character set

PL/SQL queries select Userenv (' language ') from dual

3.2 Viewing the client character set and modifying

Open the registry, "Start"-"Run" input ' regedit '-OK.

Locate the hkey_local_machine\software\oracle\key_oradb11g_home1, locate the Nls_lang option, double-click, and modify the "service-side character set".

3.3 Modifying environment variables

If the above steps are error-free (I'm going to do the third step myself), modify the environment variable Nls_lang value to "service-side Character Set" (if not nls_lang please add)

Oracle Server and client character set different result in Chinese garbled solution