When querying Oracle database using Plsql Developer and Dbvisualizer, query data is garbled in Chinese.
Look at the database encoding format
SELECT * from V$nls_parameters;
View the encoded value as WE8ISO8859P1. and the computer environment variable Nls_lang value is American_america. ZHS16GBK. Change to
American_america. It's good to restart the tool after WE8ISO8859P1. If you do not have this environment variable, you can create a new one and change the encoded value to be consistent.
My machine is here, and it is said that there is a need to change the value in the registry.
Run---->regedit-------->f3 Find Nls_lang-----> Modify Registry (Discreet)
Hkey_local_machine/software/oracle/homeo/nls_lang
This value is changed to be consistent with the database server
Note: If you do not rest assured, modify the key value: Hkey_local_machine/software/oracle/all_homes/id0/nls_lang.
garbled when querying Oracle database using Plsql developer and Dbvisualizer