Myeclipse connects to the MySQL database named MySQL and inserts Chinese data to summarize the failure

Source: Internet
Author: User
1) create a table from MySQL (MySQL here refers to the database rather than the database software), and set to add Chinese characters. The Code is as follows:
Create Table ef_ads_position
(
Position_key varchar (40) not null,
Position_readme varchar (400) not null,
Position_showtypes varchar (400) not null,
Primary Key (position_key)
) Engine = InnoDB default charset = utf8;
2) the code for inserting Chinese data into the table ef_ads_position is as follows:
Insert into 'ef _ ads_position 'values ('index _ buttompopup', 'popup ad at the bottom of the homepage ', '71'), ('index _ float', 'floating advertisement on the homepage ', '51 '), ('index _ floatscrollleft', 'Left side of homepage couplet ads', '61'), ('index _ floatscrollright', 'right side of homepage couplet ads ', '61 '), ('page _ banner', 'top banner ads', '1'), ('page _ head', 'page header position banner ads ', '1, 2, 3 '), ('page _ headerhalf', 'page header position banner _ half-cut', '1, 2, 3 '), ('page _ headtop ', 'Top ad of page', '41'), ('page _ newwin ', 'Pop-up ad', '31'), ('Post _ contentright ', 'Post _ listcenter', '1'), ('Post _ listcenter', 'post-floor middle ads', '1'), ('Post _ signedbottom ', 'Ad under personal signatures ', '1, 2, 3'), ('index _ picsrotate', 'homepage multi-graph ad rotation ', '1 ')
;
The running error information is more integrated. After careful debugging, you cannot insert Chinese characters, but the English language is normal, sqlyog enterprice, another MySQL visualization software, can insert Chinese and English data.
Summary:
1. this may be a software problem with myeclipse. Because myelipse needs to connect to MySQL through the driver, the driver may fail to correctly analyze the data while transmitting Chinese data, resulting in syntax errors, of course, MySQL software is in English version, so the syntax is certainly not messy when English data is transmitted.
2. it may be because MySQL already exists after it is installed, so it cannot set the same UNICODE attribute as other databases, but this cause may not be blocked, because sqlyog using ice does not show errors like in myelipse, it is only for reference.
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.