OK, understood, thanks but can anyone explain me I was creating db of different sensors, I used same methods, but in fields which were FLOAT were filling with junk values (after 6 decimal places, see in SENSOR_1) why? even I was cutting it to 6 decimal places (as shown previously, was then again converting into FLOAT before insertion), when I used VARCHAR(TEXT), in different table with same methods, then was getting correct (formatted, upto 6 decimal places, see in latitude, longitude) values in SENSOR_99, please have a look...
Thank you very much :) On Sat, Feb 7, 2015 at 7:39 PM, Igor Tandetnik <i...@tandetnik.org> wrote: > On 2/7/2015 8:47 AM, Abdul Aziz wrote: > >> Thanks for reply....but I am now using VARCHARS, then how this is working? >> not generating any errors? >> > > When Tim said "Read this", he meant it. http://www.sqlite.org/ > datatype3.html answers your questions (but only if you read it). > -- > Igor Tandetnik > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
