Thanks for reply....but I am now using VARCHARS, then how this is working? not generating any errors?
Please elaborate, my query to create DB is: mSQLiteDatabase.execSQL("CREATE TABLE " + tableName + " ( " + EVENT_TIME + " INTEGER, " + SYSTEM_TIME + " INTEGER PRIMARY KEY, " + ACCURACY + " INTEGER," + X + " VARCHAR, " + Y + " VARCHAR, " + Z + " VARCHAR );"); On Sat, Feb 7, 2015 at 7:08 PM, Tim Streater <t...@clothears.org.uk> wrote: > On 07 Feb 2015 at 05:57, Abdul Aziz <abduldblog...@gmail.com> wrote: > > > *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...* > > Read this: > > http://www.sqlite.org/datatype3.html > > Note that: > > 1) There are no varchars in SQLite > > 2) Floats always occupy 8 bytes > > -- > Cheers -- Tim > > _______________________________________________ > 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