[http://www.sqlite.org/cvstrac/tktview?tn=3906]
The shell is deciding that a string looks like a number and then generating an insert that way. This is an unwarranted conversion but also loses information such as leading zeroes and probably also messing with strings that have digits and the letter E in them.
<pre>
sqlite> CREATE TABLE test_table(city TEXT, zip TEXT);
sqlite> INSERT INTO test_table VALUES('Cambridge','02139');
sqlite> select typeof(city), typeof(zip) from test_table;
text|text
sqlite> .mode insert
sqlite> select * from test_table;
INSERT INTO table VALUES('Cambridge',02139);
</pre>
<hr><i>shane added on 2009-10-22 19:38:33:</i><br>
Check-in [ab99faca6c].
<hr><i>shane added on 2009-10-22 21:27:32:</i><br>
Also check-in [790402c150].
|