SQLite Forum

Integer becomes blob
The image you link shows why you believe that some values in a column were rendered from a BLOB result.  It provides no hint whatsoever as to what might have led to this. Nor does it establish that SQLite actually returned BLOB values in the corresponding rows.

I can assure you that SQLite does not randomly return BLOBs when integers have been stored in a column with INTEGER affinity, nor does it do so after any number of rows were returned as stored.

So, to give anybody a clue as to what is happening before the end result you dislike, you are going to have to show what SQLite operations led to whatever application you screenshot displaying what you (and now we) can see.