Truncated incorrect DOUBLE value Solution

Truncated incorrect DOUBLE value solution the project encountered the "1292 truncated incorrect double value" error when operating the MYSQL database VARCHAR field. The MYSQL manual says: Error: 1292 SQLSTATE: 22007 (ER_TRUNCATED_WRONG_VALUE)
Message: Incorrect % s value truncated: '% s' www.2cto.com what is incorrect % s value truncated? Is it not allowed to directly null or assign values directly. Think twice.

At last, I found some other possible problems on the Internet, but they are not exactly the same.

In other people's cases, "+" is often used to add strings incorrectly, rather than the library function "concat ". This method is used to add the field strings. But the key is that my problem is direct assignment instead of string connection.

Finally, we used the concat function: concat (Str, '') to solve the problem in disguise.