PL/SQL Developer encoding format set one, PL/SQL developer in the text field display garbled reason: Because the database number format and PL/SQL Developer encoding format is not uniform caused. TwoView and modify 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 bytesfixed size 452044 bytesvariabl E size 109051904 bytesdatabase buffers 25165824 bytesredo buffers 667648 bytesdatabase mounted.sql> alter system enable Restricted Session;system altered.sql> alter system set JOB_QUEUE_PROCESSES=0;SYSTEM altered.sql> alter system set Aq_tm_processes=0;system altered.sql> ALTER DATABASE open;database altered.sql> ALTER DATABASE character set Inter Nal_use ja16sjis;sql> shutdown immediate;sql> startup; ThreeModify the encoding format of PL/SQL Developer (i.e. customer service character set): 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.
PL/SQL Developer encoding format settings