I use sqlite in conjunction with html5: WebSQL

numeric value in a VARCHAR and TEXT column

In VARCHAR or TEXT columns a numeric value, e.g. 160105, is not inserted as a string but as a float, i.e. 160105.0

I did not find a way to get rid of this behaviour maintaining the same types ;-) So, I ended up using the type BLOB instead.