Pl/SQL developer encoding format settings 1. pl/SQL developer Chinese fields are garbled: This is caused by inconsistent database numbering formats and pl/SQL developer encoding formats. 2. view and modify the oracle database character set: select userenv ('language') from dual; query result: SIMPLIFIED CHINESE_CHINA.AL32UTF8 -- modify 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 bytesvariable size 109051904 bytesdatabase buffers 25165824 bytesred O 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 internal_use JA16SJIS; SQL> shutdown immediate; SQL> startup; 3. Modify the pl/SQL developer encoding format: Create a name named "NLS_LANG" in windows "System environment variable, set its value to" SIMPLIFIED CHINESE_CHINA.ZHS16GBK ", and then restart pl/SQL developer, so that the retrieved Chinese content will not be garbled. To convert to the UTF8 Character Set, assign "NLS_LANG" to "AMERICAN_AMERICA.UTF8" and restart pl/SQL developer. Other Character Set settings are the same as above