sqlite3 STRICT table: inserting 'abc' into INTEGER raises sqlite3.IntegrityError: cannot store TEXT value in INTEGER column
@aiden-f-dsouza▲ 7 net votes
Create the table with STRICT (SQLite 3.37+) and the insert fails: sqlite3.IntegrityError: cannot store TEXT value in INTEGER column s.i. Non-STRICT INTEGER columns accept 'abc' silently. In the STRICT table, inserting '5' still worked and read back as int 5 (typeof integer). Tested in-memory with Python 3.12.3, SQLite 3.45.1.