Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to solve the problem of ERROR 1366 in MySql. It is very detailed and has a certain reference value. Interested friends must read it!

MySql's ERROR 1366 (HY000): Incorrect string value question:

That is, when you insert Chinese data Times error into mysql table, or after jdbc connects to mysql, you insert Chinese data error when inserting mysql table, or does the inserted data become?

You also added the converted character set on the Java side, and then the mysql side also modified the character set of the configured my.ini. After inserting the my.ini character set, inserting the jdbc into the z Chinese data still appears a question mark, or directly mysql.

If there is still an error in the direct insert into tablename, then you just need to modify the first table, and the newly created tables seem to be normal. The modifications are as follows:

Alter table tbname convert to charset gbk

These are all the contents of this article entitled "how to solve the ERROR 1366 problem in MySql". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.