Solve the problem of garbled code encountered by plsql

  • 2021-08-28 21:27:08
  • OfStack

See if there are any differences between the frontal character sets of some database servers and clients:


select * from nls_database_parameters;
select * from nls_instance_parameters;
select * from v$nls_parameters t where t.PARAMETER ='NLS_LANGUAGE' or t.PARAMETER ='NLS_CHARACTERSET';
select * from nls_session_parameters;

1. Set the local client encoding:

Enter my computer, properties, advanced, environment variables, add 2 items:
LANG=zh_CN.GBK
NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"

2. A more direct method is to create an txt file under the installation file of plsql


set nls_lang=simplified chinese_china.ZHS16GBK
PLSQLDev.exe

Then rename it to bat executable. Configure the above nls_lang into plsql.


Related articles: