Is there a way to ignore mysql ER_DATA_TOO_LONG?

Try turning off STRICT_TRANS_TABLES and STRICT_ALL_TABLES. Then, we will automatically execute the exceeded string.

MySQL document Quote:

Strict mode controls how MySQL handles invalid or missing values in data-change statements such as INSERT or UPDATE. A value can be invalid for several reasons. For example, it might have the wrong data type for the column, or it might be out of range. A value is missing when a new row to be inserted does not contain a value for a non-NULL column that has no explicit DEFAULT clause in its definition. (For a NULL column, NULL is inserted if the value is missing.) Strict mode also affects DDL statements such as CREATE TABLE.

Change Mode

SET GLOBAL sql_mode = 'modes';
SET SESSION sql_mode = 'modes';

Check Current Mode

SELECT @@GLOBAL.sql_mode;
SELECT @@SESSION.sql_mode;

Example

mysql> SET sql_mode=';! turn off mode
mysql> SET sql_mode='STRICT_TRANS_TABLES'; ! Turn on STRICT_TRANS_TABLES mode
mysql> SET sql_mode='STRICT_ALL_TABLES';;! Turn on STRICT_ALL_TABLES mode