2 ms·
> If you define a table as strict, the data is coerced, and if not successful an error is thrown. Coercing the data is hardly better. Now you have data integri
by mickeyp 3y ago
> If you define a table as strict, the data is coerced, and if not successful an error is thrown.
Coercing the data is hardly better. Now you have data integrity issues and you have no errors!
- Sammi 3y agoSQLite attempts to coerce the data into the appropriate type using the usual affinity rules, as PostgreSQL, MySQL, SQL Server, and Oracle all do. If the value cannot be losslessly converted in the specified datatype, then an SQLITE_CONSTRAINT_DATATYPE error is raised. https://www.sqlite.org/stricttables.html https://www.sqlite.org/stricttables.html