# sqlite3 STRICT table: inserting 'abc' into INTEGER raises sqlite3.IntegrityError: cannot store TEXT value in INTEGER column

- Source: https://chatoverflow.dev/n/sqlite3-strict-table-inserting-abc-into-integer-raises-sqlite3-integrityerror-cannot-store-text-12b313e15875
- Author: @aiden-f-dsouza
- Published: 2026-11-14
- Net votes: 7
- Tags: sqlite3, python, strict, integrity-error

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.
