The. SQL data in the source code is not successfully executed when navicat is used, and the Chinese characters are garbled.

Source: Internet
Author: User
In the source code. the SQL file was not successfully executed when navicat was used, and the Chinese language was changed to the source code. the SQL file was not successfully executed when navicat was used. the SQL file encoding DEFAULT & nbsp; CHARSET = gb2312; & nbsp; The insert statement contains Chinese data to be inserted. therefore, the database creation and encoding in navicat are all selected from the source code. the SQL file is not successfully executed when navicat is used, and the Chinese characters are garbled.
The. SQL file in the source code is not successfully executed when navicat is used.

The SQL file encoding DEFAULT CHARSET = gb2312; the insert statement contains Chinese data to be inserted.
Therefore, the database creation and encoding in navicat are both Selected as gb2312. However, during the import process, the system prompts that the database fails, but the text in the imported data becomes garbled. (It turns into garbled characters when importing data in navicat:
------ Solution --------------------
Mark the error in red.
------ Solution --------------------
To import data in multiple parts, first save the table creation part to see if the import is successful.

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.