Oracle client and PLSQL query data garbled modified into Chinese fast solution _oracle

1, query Oracle Server language, geography and character set

SELECT * from Nls_database_paameters;

The results of the query are shown below

Nls_language represents "language", nls_territory means "geographical", Nls_charactset represents "character set", and the three of them are spliced in accordance with the format of "language _ region. Character Set", there is "American_america". ZHS16GBK ".

The following formal operation:

2, add local environment variables: Nls_lang,

Enter My computer, properties, advanced, environment variables, and then modify them to the following values without adding 1 items:

Nls_lang= "American_america. ZHS16GBK "2, press the Win+r (win is the button with the Microsoft icon), input: Regedit open the registry. To modify the "hkey_local_machine->software->oracle->key_oraclient11g_home1" in the local registry-----Right-click nls_lang--Click--Modify- The numerical data is changed to: American_america. Zhs16gbk

3, may be a lot of small partners are green to enter the registry without Oracle This option is very frustrating. Because it could be a 32-bit reason, you go down to the registry to see Hkey_local_machine->software->wow6432node to see if there are any Oracle options, and if not, add a The code below establishes the registry of two suffixes named American_10g.reg and Chinese_10g.reg;

Windows Registry Editor Version 5.00
[hkey_local_machine\software\oracle\key_oradb10g_home1]
"Nls_lang" = " American_america. Us7ascii "and
Windows Registry Editor Version 5.00
[hkey_local_machine\software\oracle\key_oradb10g_home1] "
Nls_lang" = "Simplified Chinese_china." ZHS16GBK "

4, my plsql is installed here D:\Program files\plsql Developer "After you download the registry under the Plsql directory to run , press the Win+r (win is the button with the Microsoft icon), Input: Regedit open the registry. To modify the "hkey_local_machine->software->oracle->key_oraclient11g_home1" in the local registry-----Right-click nls_lang--Click--Modify- The numerical data is changed to: American_america. ZHS16GBK, remember to re-enter the previous database data.

The above is a small set to introduce the Oracle client and PLSQL query data garbled modified into Chinese fast solution, I hope to help you, if you have any questions please give me a message, small series will promptly reply to everyone. Here also thank you very much for the cloud Habitat Community website support!