The dump from sqlite2 is not a text value. It is a real value. Note there are no quotation marks around the value. ``` # sqlite new.db .dump CREATE TABLE "xyz" ( "xyz_id" INTEGER NOT NULL,"xyz_value" VARCHAR NOT NULL,"xyz_order" INTEGER DEFAULT 0); INSERT INTO xyz VALUES(1,1536273869.654473892,0); COMMIT; ``` So when this statement is executed by SQLite3 the value treated as a REAL (Double Precision Floating Point -- not as a text string) and converted to text (by printing it, basically) for storage in the text field. You may not like this but I assume that this is just how sqlite2 works when it exports text that looks like a number.