PL/SQL Developer connection to database and the problem of Chinese garbled in Oracle database

Source: Internet
Author: User

Today, the second configuration of PL/SQL developer, said that the egg hurts, yesterday because moved a thing and then inexplicably can not connect the database, always show a variety of
Error, I moved the thing is because the Chinese will show garbled, (because I am using 32-bit PL/SQL developer to connect 64-bit Orcale, so refer to the online tutorial in the Tim
Add an environment variable name is Nls_lang, and the value is simplified Chinese_china. ZHS16GBK, and then changes the value of the name under the registry to this
Kind of, and then I log on again to show a variety of errors, not even to change back, but also try to re-create a new database, finally reinstall Oracle resolved, and because I uninstalled
Not clean finally still through the reload system and then reload the database, really around a good big a bend, and then installed after the configuration, once again appear the same error, then no language,
This time I decided to try a different approach, and then I tried to delete the path to the Oci.dll library and rerun the following script once:
@echo off
Set Path=d:\app\xiaxiaosheng\product\instantclient_10_2
Set Oracle_home=d:\app\xiaxiaosheng\product\instantclient_10_2
Set Tns_admin=d:\app\xiaxiaosheng\product\instantclient_10_2
Set Nls_lang=simplified Chinese_china. Zhs16gbk
Start Plsqldev.exe

The result will be. Finally no longer have to toss.

Then it is about the Chinese garbled problem, in fact, I read the tutorial about the text of this script in the tutorial set the value of this Nls_lang is set when the American_america. Al32utf8 this,

But the value inside the server registry is simplified Chinese_china. ZHS16GBK, the code inconsistency caused the Chinese display garbled.

PL/SQL Developer connection to database and the problem of Chinese garbled in Oracle database

Related Article

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.