Solve the issue of garbled characters in Oracle PL Developer

We all know that garbled characters often occur in the actual operations of Oracle PL Developer. This problem has always plagued us and we hope to find a useful solution, the following article describes how to solve the Chinese garbled characters of Oracle PL Developer.

1.

 
 

  
  
select * from v$nls_parameters 
 
 

Query nls parameters to obtain the character encoding of the database server.

 
 

  
  
NLS_LANGUAGE  
  
  
NLS_CHARACTERSET  
 
 

2. Modify local environment variables and set

 
 

  
  
NLS_LANG = SIMPLIFIED CHINESE.ZHS16GBK 
 
 

This is the character encoding of our database.

Oracle PLDeveloper Chinese garbled solution: NLS_LANG format:

 
 

  
  
NLS_LANG = language_territory.charset 
 
 

Has three components: language, region, and character set. Each component controls the NLS subset. Language indicates the language of the server message.

Territory specifies the date and number format of the server.

Charset

You can also change the corresponding registry key.

 
 

  
  
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_XE\NLS_LANG 
 
 

Ensure that the client character set must be consistent with the server character set. All of the above are solutions to change the Chinese garbled characters of Oracle PLDeveloper.