The problem is you are storing REAL values in a TEXT column. asql> create table tvr (t text, r real); asql> insert into tvr values (1536738388.3623876328,1536738388.3623876328); asql> .dump PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; CREATE TABLE tvr (t text, r real); INSERT INTO "tvr" VALUES('1536738388.36239',1.53673838836238765715e+09); COMMIT;