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.
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.
