SQLite Forum

Integer becomes blob
Login
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:
```sql
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 :

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

~~~
-- 
Regards,
Kees Nuyt
~~~