The FAQ basically admit it was a design mistake to make "flexible typing" the default, but it is too late to fix due to backwards compatibility. https://sqlite

The FAQ basically admit it was a design mistake to make "flexible typing" the default, but it is too late to fix due to backwards compatibility. https://sqlite.org/quirks.html#flexible_typing https://sqlite.org/quirks.html#flexible_typing It is probably not as big a problem in an embedded database as it would be in a server-based database. Nevertheless "flexible typing" should have been an opt-in feature per column, not the default.