PL/SQL Import a file in Chinese garbled solution

Source: Internet
Author: User

The PL/SQL export file Xx.sql file, which was received from elsewhere, was imported into the local library with the import function in the PL/SQL tool and found that the comment comment of the table is garbled and can be resolved by the following methods, as follows:

1) Enter the PL/SQL installation directory: My directory is "E:\Program Files (x86) \plsql Developer\"

2) Create a new Startplsql.bat file within the directory with the file content

Set Oracle_home=e:\app\again\product\11.2.0\dbhome_1

Set Path=e:\app\again\product\11.2.0\dbhome_1

Set Tns_admine=e:\app\again\product\11.2.0\dbhome_1\network\admin

Set Nls_lang=american_america. Al32utf8

Start Plsqldev.exe

3) Open uedit text editing software, create a new text, select "View"-"View code page", select UTF-8 and save, copy the contents of Xx.sql file to the page, save as Zmxx.sql file, save pop-up box, drop-down select format as UTF-8

4) Execute the startplsql.bat file, start PL/SQL automatically, and import the Zmxx.sql in the Execute Import Import tool.

PL/SQL Import a file in Chinese garbled solution

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.