Blog: NS en de gestoorde storingen

Zelfs de storingen doorgeven brengt de NS al in problemen:

Op de pagina met storingen op NS website staat: ‘Tijdelijk geen actuele informatie i.v.m. een storing.Onze excuses daarvoor.’

Blog artikel van 1 februari 2008.

Kort nieuws


Programming: 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.

Programming article from 20 april 2008.