PL/SQL Developer Text Field display garbled solution

Reason: Because the database number format and PL/SQL Developer encoding format is not unified.

Second, view and modify the Oracle database character set:

Select Userenv (' language ') from dual;

Query Result:

American_america. Zhs16gbk

--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 bytesvariable 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 Internal_use Ja16sjis;

sql> shutdown immediate;

Sql> startup;

Third, modify the format of PL/SQL developer encoding:

Create a system environment variable named "Nls_lang" in Windows and set its value to "American_america." ZHS16GBK ",

Then restart the 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 Text Field display garbled solution