PL/SQL Developer connection 64-bit database garbled error

Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the following sources, otherwise, the legal responsibility to pursue copyright.

Deep Blue Blog:http://blog.csdn.net/huangyanlong/article/details/41479997

After installing the 64bit oracle11g database, use PL/SQL to connect the database to solve the "Chinese characters" garbled problem

Site Environment

Operating system	WINDOWS 64bit
Database version	oracl11g 64bit 11.2.0.3
PL/SQL version	10.0.2.1697

Description: PL/SQL software can only connect 32-bit databases, so if you need to connect a 64-bit database with it in practice, you need to install 32-bit clients.

Implementation Action

implementation uses PL/SQL to connect the oracle11g database.

when I was deploying, I referred to a summary of my previous experience: http://blog.csdn.net/huangyanlong/article/details/18466053

But there was an error in the production library.

An error occurred while using the following behavior:

Error phenomenon: garbled characters appear.

Workaround

Check the database language settings:

Sql> Select Userenv (' language ') Nls_lang from dual;

Nls_lang

----------------------------------------------------

Simplified Chinese_china. Zhs16gbk

Right-click My Computer-Properties-advanced-environment variables-system environment variables:

1> Select "Path"-click "Edit" to add "D:\soft\app\Administrator\product\ instantclient_11_2;"

2> Click "New", the variable name is set to "Tns_admin", the variable value is set to "D:\soft\app\Administrator\product\ instantclient_11_2;", click "OK";

3> Click "New" and the variable name is set to "Nls_lang" and the variable value is set to "simplified Chinese_china. ZHS16GBK ", click" OK ";

Execute PL/SQL Developer again, Chinese is displayed correctly, as shown below:

Summary

Using PL/SQL developer by installing a 32-bit client, successfully resolved the connection 64-bit database, but the Chinese characters garbled problem, the original is the Windows system, you also need to set the appropriate environment variables.

Follow-up network find information

Here is an online search on the use of PL/SQL Developer Connection 64-bit database method, the summary has been very comprehensive, reproduced here, to share to friends.

The following is reproduced:

1) Install Oracle 11g 64-bit

2) Installing the 32-bit Oracle Client (instantclient-basic-win32-11.2.0.1.0)

: http://www.oracle.com/technetwork/cn/topics/winsoft-095945-zhs.html

Download Instantclient-basic-win32-11.2.0.1.0.zip (must be 32-bit, do not make the wrong version, the Oracle website has downloaded), Unzip it to product under the Oracle installation directory (this machine is named: instantclient_11_2): D:\app\ZC\product\instantclient_11_2.

Copy a directory under the root directory of the database installation D:\app\ZC\product\11.2.0\dbhome_1\NETWORK to the Oracle client directory D:\app\ZC\product\instantclient_11_ 2 (actually only need Network\admin\tnsnames.ora)

3) Install PL/SQL Developer

Install PL/SQL Developer, set up OCI library and Oracle_home in Perference->connection, for example, native settings:

Oracle home:d:\app\zc\product\instantclient_11_2

OCI Library:d:\app\zc\product\instantclient_11_2\oci.dll

4) Set Environment variables (modify path and tns_admin environment variables) for Nls_lang environment variables, preferably set to the same database side, first query the character set information from the database side:

Sql> Select Userenv (' language ') Nls_lang from dual;

Nls_lang

----------------------------------------------------

Simplified Chinese_china. Zhs16gbk

Right-click My Computer-Properties-advanced-environment variables-system environment variables:

1> Select "Path"-click "Edit" to add "D:\app\ZC\product\instantclient_11_2;"

2> Click "New", the variable name is set to "Tns_admin", the variable value is set to "D:\app\ZC\product\instantclient_11_2;", click "OK";

3> Click "New" and the variable name is set to "Nls_lang" and the variable value is set to "simplified Chinese_china. ZHS16GBK ", click" OK ";

Finally click "OK" to exit.

Start PL/SQL Developer and run without problems.

Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the following sources, otherwise, the legal responsibility to pursue copyright.

Deep Blue Blog:http://blog.csdn.net/huangyanlong/article/details/41479997

PL/SQL Developer connection 64-bit database garbled error