This article is a mirror article of machine translation, please click here to jump to the original article.

Architect_Programmer_Code Agriculture Network»Architect › Database & Database › MySQL › Error Code: 1366. Incorrect string value: '\xE4\xB8\ ...
View: 18141|Reply: 1

[Source] Error Code: 1366. Incorrect string value: '\xE4\xB8\x8A\xE6\xB5\xB7...' for c...

[Copy link]
Posted on 6/30/2017 9:31:51 AM | | | |
Error Code: 1366. Incorrect string value: '\xE4\xB8\x8A\xE6\xB5\xB7...' for column 'tab1' at row 1


When I insert data, I execute an error,

For error reasons and coding problems, let's check the encoding format of the database, as follows:



The encoding format of the database is latin1, and the data we insert is in utf8 format.

Solution:

If you find that after modifying the database encoding or inserting errors, you should still modify the encoding format of the table and table fields

So, let's just delete the database and rebuild it! Ha ha

ok

Score

Number of participants1MB+1 contribute+1 Collapse reason
Hug your big brother's thigh + 1 + 1 Very powerful!

See all ratings





Previous:Error thrown by a dependency of object 'MySql-5.2.3' defined in 'assembly [S
Next:【Absolute Protection against Ransomware】Computer company Ghost Windows 7 32-bit, 64-bit ultimate version v201707

Related Posts
Posted on 9/6/2018 4:59:59 PM |
I haven't been exposed to the new mysql, which means it's very easy to use, and the crab crab sticks to the owner
Disclaimer:
All software, programming materials or articles published by Code Farmer Network are only for learning and research purposes; The above content shall not be used for commercial or illegal purposes, otherwise, users shall bear all consequences. The information on this site comes from the Internet, and copyright disputes have nothing to do with this site. You must completely delete the above content from your computer within 24 hours of downloading. If you like the program, please support genuine software, purchase registration, and get better genuine services. If there is any infringement, please contact us by email.
Mail To:help@itsvse.com