re: #728 Alouette

One apostrophe in a database record can totally fuck up an entire web report.

I do battle every other day with other people’s mad ideas about how to store data.

Here are my two golden rules: obey them and you will go far, little software package:

1) If the data validation rules dictate that only valid numbers can be entered, then store the entered values as numbers. NOT TEXT. AND ESPECIALLY NOT TEXT WITH LEADING ZEROS.

2) Entered data is not a date UNLESS I TELL YOU IT IS.