SQLite Forum

Integer becomes blob
Find a row that has a blob that you think ought to be an integer.  
Find this very same row in your source data that is getting sent to the INSERT statement.  
Examine the "thing" that you think should be an "integer" and see what it is.  
Thus will your problem be revealed to you.  (Hint -- what you are sending is not an integer)