How to solve: mysql Error Code: 1406. Data too long for column

How to solve: mysql Error Code: 1406. Data too long for column

December 30, 2019

You need to get rid of MySQL "strict" mode.

SELECT @@global.sql_mode;
SELECT @@SESSION.sql_mode;

SET global sql_mode='';
SET session sql_mode='';

Or some other mode without "strict".

See also:

How to get rid of STRICT SQL mode in MySQL

Comments