Oracle and PLSQL Developer encoding settings

When using PL/SQL developer, the query out of the text field is garbled, because the database number format and PL/SQL Developer encoding format is not uniform caused.

I. Viewing and modifying the Oracle database character set

Select Userenv (' language ') from dual;--query result: simplified Chinese_china. al32utf8--Modifying the Oracle Database Character set: (In SQL Plus) sql> conn/as sysdba;sql> shutdown immediate;database closed.database Dismounted.oracle instance shut down.sql> startup Mount;oracle Instance started.total system global Area 135337420 byte Sfixed size 452044 bytesvariable size 109051904 bytesdatabase buffers 25165824 bytesredo buffers 667648 bytesdatabase Moun Ted.sql> alter system enable restricted Session;system altered.sql> alter system set Job_queue_processes=0;system a Ltered.sql> alter system set AQ_TM_PROCESSES=0;SYSTEM altered.sql> ALTER DATABASE Open;database altered.sql> ALTER DATABASE character set Internal_use ja16sjis;sql> shutdown immediate;sql> startup;

Ii. Modifying the code of PL/SQL developer

Create a system environment variable named "Nls_lang" in Windows and set its value to "simplified Chinese_china. ZHS16GBK ", and then restart PL/SQL developer, so that the retrieved Chinese content will not be garbled. If you want to convert to the UTF8 character set, you can assign "Nls_lang" to "American_america." UTF8, and then restart the PL/SQL developer. Other character set settings ibid.

Oracle and PLSQL Developer encoding settings