Plsql Query Results Chinese garbled

Source: Internet
Author: User

There are many tutorials on the web, but here's how to modify the Oracle parameters in the registry if the Oracle client is not installed?

Of course, some do not need to change the registry, only need to configure the environment variables can be, but sometimes found that after the change is not so, in this case can only modify the registry.

  

You go to the bottom of the registry to see Hkey_local_machine->software->wow6432node see if there is an Oracle option, if not yet we add one; The code is set up as follows two suffix named American_ 10g.reg and Chinese_10g.reg (the name is not important, the key is the suffix name) of the registry;

You can save the content to Notepad first, then change the suffix to Reg, and then drag and drop it into the registry, which automatically matches the location according to the path.

123456 windows Registry Editor Version 5.00 [hkey_local_machine\software\oracle\key_oradb10g_home1] = "American_america. Us7ascii "
  windows Registry Editor Version 5.00 [hkey_local_machine\software\oracle\key_oradb10g_home1] "Nls_lang" = "Simplified Chinese _china. ZHS16GBK "

My plsql is installed here D:\Program files\plsql Developer "After you download the registry in the Plsql directory after running, press Win+r (Win is the button with the Microsoft icon), enter: Regedit to 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 value data is changed to: American_america. ZHS16GBK, remember to re-enter the previous database data. (see if it is already GBK, you do not need to modify it)

Plsql Query Results Chinese garbled

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.