Oracle client connection remote Oracle service Chinese garbled problem, oracle Chinese

Oracle client connection remote Oracle service Chinese garbled problem, oracle Chinese

When the local machine remotely connects to the remote Oracle service, the following retrieval statement is written:

Select * from sys_employee

Chinese garbled characters appear in the results, but the remote server's PL/SQL retrieval is correct.

Solution:

Step 1:

Select * from v $ nls_parameters

Obtain execution results

 

Step 2:
SELECT 'American _ AMERICA. '| PROPERTY_VALUE
FROM DATABASE_PROPERTIES

Obtain execution results

Step 3: Configure environment variables:

Add two configurations in the system Variable Area

NLS_CHARACTERSET = ZHS16GBK

NLS_LANG = AMERICAN_AMERICA.ZHS16GBK