l Aziz
>Sent: Saturday, 7 February, 2015 07:22
>To: General Discussion of SQLite Database
>Subject: Re: [sqlite] Bug in SQLite FLOAT values
>
>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
On 7 Feb 2015, at 2:22pm, Abdul Aziz wrote:
> but in fields which were FLOAT were
> filling with junk values (after 6 decimal places, see in SENSOR_1) why?
Take a look at what happens when you try to write 1/13th in decimal:
0.076923076923076923076923076923076923076923076923076923.
What a
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 co
un...@sqlite.org [mailto:sqlite-users-
>boun...@sqlite.org] On Behalf Of Kees Nuyt
>Sent: Saturday, 7 February, 2015 18:14
>To: sqlite-users@sqlite.org
>Subject: Re: [sqlite] Bug in SQLite FLOAT values
>
>On Sat, 7 Feb 2015 11:27:59 +0530, Abdul Aziz
>wrote:
>
>> Hi there
On Sat, 7 Feb 2015 11:27:59 +0530, Abdul Aziz wrote:
> 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 receiv
On 7 Feb 2015, at 5:57am, Abdul Aziz wrote:
> *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 d
On 2015/02/07 15:47, Abdul Aziz wrote:
Thanks for replybut 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 + " INTE
On 2/7/2015 8:47 AM, Abdul Aziz wrote:
Thanks for replybut 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
_
Thanks for replybut 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,
On 07 Feb 2015 at 05:57, Abdul Aziz 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 whil
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
val
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
val
12 matches
Mail list logo