SQLite Forum

about "strict" mode
Login
> Restrict column data type names in CREATE TABLE statements to one of INT, INTEGER, REAL, BLOB, TEXT so that we always know exactly which datatype is allowed in that column.

This is a very interesting point as it caused strict mode to be more restrictive than standard SQL. Is that really the goal? Shouldn't all SQL data types (especially DATE, TIME, DATETIME which often led to confusion or inquiries here) be allowed but just behave as declared. So inserting a well-formated date into a date field should be fine, imho.

Edit: what about foreign-key-enforcement? While following the discussions here, I notice that even experts seem to sometimes forget about "pragma foreign_keys=on".