MySQL STRICT_TRANS_TABLES mode and truncated text values

I just upgraded Apache, PHP and MySQL to their current versions on my development system. After that a unit test of one of my PHP classes failed on inserting a row in a MySQL table. The test inserts text with a greater length than the maximum column length of a VARCHAR column.

This test fails because the new server runs with STRICT_TRANS_TABLES mode. It means that a inserted value must be equal to the stored value or the statement fails. Without the mode setting the inserted value is truncated to the column’s maximum length.

Verkeersbordententoonstelling

Deze verzameling borden staat bij de Cronjé, die sinds afgelopen weekend overdag voetgangersgebied is.