[PLSQL Developer] PLSQL Developer SQL Editor garbled, plsqldeveloper

Source: Internet
Author: User

[PLSQL Developer] PLSQL Developer SQL Editor garbled, plsqldeveloper
[Problem] We often write various statements in the SQL window of PLSQL Developer. To save these statements, you can save them as a text file or copy them and paste them into a Word file, the advantage of storing the statement in a Word file is that the statement retains the original format and can clearly distinguish keywords and constants. However, when a statement contains Chinese characters, the Chinese characters in the statement pasted into the Word file cannot be displayed.

[Analysis] This is because the character set in the SQL editing window is not a Chinese character set. You can change this character to integrate Chinese.
[Solution]
1. Click Preferences under the Tools menu...

2. Click Fonts under the User Interface, and then click Select... under the Editor on the right.

3. In the pop-up window, select a Chinese font, such as, and then select the character set CHINESE_GB2312. OK.


Plsql developer garbled

Find the following solutions elsewhere:
1. Set the key value of HKEY_LOCAL_MACHINE-> SOFTWERE-> ORACLE-> HOME0-> NLS_LANG in the Registry to Japan. In addition, all fonts under Tools> Preferences> font of Plsql developer are changed to Japanese.
I don't know whether to use it or not. I have never used a Japanese system ~~

The Chinese data entered by plsql developer becomes garbled

If you don't understand what you mean, you can see that your graph is an insert statement, which means that you are garbled before the insert statement. Do you first write the insert statement in the win editor and paste it into unix? If this is the case, you should use ftp to send this script.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.