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.