Pl/SQL developer encoding format settings, pldeveloper

Pl/SQL developer encoding format settings, pldeveloper

When we use plsql, sometimes the encoding format of the database and plsql is incorrect, and we need to change the encoding format.

The solution is as follows:

Original article: http://blog.csdn.net/fmhui879/article/category/954622

 

1. garbled characters in pl/SQL developer Chinese fields
Cause: the numbering format of the database and the encoding format of pl/SQL developer are inconsistent.

Ii. view and modify the character set of an oracle database:

Select userenv ('language') from dual;

Query results:

SIMPLIFIED CHINESE_CHINA.AL32UTF8

-- Modify the character set of the oracle database: (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 bytes

Fixed size 452044 bytes

Variable size 109051904 bytes

Database buffers 25165824 bytes

Redo buffers 667648 bytes

Database 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 encoding format of pl/SQL developer:

Create a system environment variable named "NLS_LANG" in windows and set it to "SIMPLIFIED CHINESE_CHINA.ZHS16GBK ",

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

PL/SQL Developer how does the software set the font size and color?

Tools-> preferences-> User Interface-> fonts (the editor also contains some)

PL/SQL Developer I set the font size and color in the editor. Why is it useless? For example:

Let's take a look at the figure. It's very simple.