SQLite Forum

Integer becomes blob
It is hard to tell at first glance what could have gone wrong.

Please show us the schema for the problem table and the insert statement you used to fill it.

Is there just one row with that problem?
You can verify with something like:
SELECT .... WHERE typeof() == 'blob' .... 

Can you spot any relation between the problem row and its source input line?

You can verify the integrity of the physical database file with :

sqlite3 /path/to/database.sqlite "PRAGMA integrity_check"

Kees Nuyt