标题:sqlie3数据库
作者:bigcwu
日期:2012-08-18 15:44
内容:
将创建好的数据库从设备下载下来后，数据库中浮点数自动转化成一个非常小的用科学计数法表示的数字，请问怎么转化回来？
#1 [bigcwu 08-18 15:46]
采用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);
#2 [liuyuanan 09-09 11:35]
路过