[提问]sqlie3数据库 [复制链接]

将创建好的数据库从设备下载下来后，数据库中浮点数自动转化成一个非常小的用科学计数法表示的数字，请问怎么转化回来？

采用sqlite3查看时在设备中存储的4.0变成了3.08258364109348e-121

1989|AI1|20120809190100|3.08258364109348e-121|78||0|0.0|0.0|
1990|AI2|20120809190100|3.08258364109348e-121|78||0|0.0|0.0|
1991|AI3|20120809190100|3.08258364109348e-121|78||0|0.0|0.0|
1992|AI4|20120809190100|3.08258364109348e-121|78||0|0.0|0.0|
1993|AI5|20120809190100|0.0|68||0|0.0|0.0|
1994|AI6|20120809190100|0.0|68||0|0.0|0.0|
1995|AI7|20120809190100|0.0|68||0|0.0|0.0|
1996|AI8|20120809190100|0.0|68||0|0.0|0.0|
1997|a19|20120817010100|4.0|0|0|0|0.0|0.0|0
sqlite> .schema
CREATE TABLE rttable(ID integer primary key, polld text, time integer, rtd real,
flag integer, sb text, rs integer, daydata real, nightdata real, extend text de
fault '0');
CREATE UNIQUE INDEX idx_rtd on rttable(polld);

路过