Data truncated for column - return fatal error
Probably you need to upgrade to 5.7 or MariaDB to get STRICT_TRANS_TABLES to give you an error (and abort the transaction) for that situation.

https://mariadb.com/kb/en/mariadb/sql_mode/
http://dev.mysql.com/doc/refman/5.7/en/sql-mode.html