Hi there! I hope you are well! Recently I was working on project based on Android Sensors and encountered a bug in sqlite db, situation was this: I was setting there three values x,y,z as FLOAT, android inbuilt sensors were receiving values as float upto 8 decimal places, but I wanted to store value only upto 6 decimal place, so in android this is the way that first you will have to convert that value into String , as* String sLongitude = String.format("%.6f", x);* *again I converted back to float this string formatted value, and printed into Log, I was clearly seeing values upto 6 decimal places , but after insertion into sqlite db, when after generation of sqlite db file, was getting values upto 11-12 decimal places!* *upto 6 decimal places were matching with my values and rest were garbage values...* *Then to avoid this I converted from FLOAT to VARCHAR into DB, and inserted that formatted values (**String sLongitude = String.format("%.6f", x)**)* *now I was getting correct formatted values from sqlite db file,*
*I think this is a bug, this means float values in sqlite will always be filled upto 11-12 decimal places, in any case, you will have to fill it, or sqlite will fill it itself with junk values, **this may create lot of consumption of memory while working on larger projects...* *Thanks, waiting for a reply....* *Abdul Aziz Ansari* _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users