One of the solutions for displaying garbled characters in pl/SQL

Source: Internet
Author: User

I am a man-level character in Oracle, so I have encountered many problems. In the last few days, oracle data queries have encountered a strange phenomenon. A database is running on a different computer and in the same environment when pl/SQL is enabled for queries. This is normal and garbled. I feel very puzzled.

Therefore, I tried to compare the character set. In pl/SQL, the character set is ZHS16GBK. There is no error. Therefore, we can compare the NLS_LANG under the oracle entry in the Registry to ZHS16GBK. There is no way. I don't know where to fix it. Think about whether the language set in the bios of the computer is incorrect. However, no exception was found after a circle was found in the bios. Or not. As a result, I found another computer to install the same environment, and then perform pl/SQL queries to find that there is no problem. This is why I am confused. There is no trick. At this time, a colleague said that the ZHS16GBK in the NLS_LANG in the registry should be changed to UTF8. So I changed ZHS16GBK to UTF8 and then performed the query. The result is normal. Haha, it succeeded.

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.