sql - Mysql 1406 Data too long for column

Question

I have a string containing more than 600 characters, where I want to Insert it in a column VARCHAR (255) column
I tested on two different databases:

1. For a mysql 5.7.31-34-log database, I ran into this exception:
   SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'name' at row 1"
   

• I dumped the sql_mode for each database and this the result:

["@@sql_mode"]=> string(40) "STRICT_ALL_TABLES,NO_ENGINE_SUBSTITUTION"

2. On the other hand for a mysql 5.7.19 database, the string is well registered into my database, but with a warning message: Level Code Message
   Warning 1265 Data truncated for column 'name' at row 1

• sql_mode:

["@@sql_mode"]=> string(0) ""

I would be grateful if someone could explain to me it is a good practice to disable strict mode, and does truncate remove a part of the string if exceeded ?

question from:https://stackoverflow.com/questions/66059735/mysql-1406-data-too-long-for-column

Answer 1

you cannot store 600 character in varchar(255) since It's allowing only 255 character.dependingvon your configuration data will be rejected or truncated after 255 character. The version of MySql you are using allow way more that 255 for varchar data type. please alter the column to extend the length. you may use varchar(600) for example.