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

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

Popular posts from this blog

Check MySQL query history from command line

Installing chocolatey on Windows