Sandeep Suresh <[EMAIL PROTECTED]> wrote: > Hi all, > > The problem is for one of the columns that have values ( 8209454, > 1254234, 1245663 ) in db_old, the values in the new database are changed > to ( 8209454.0000001, 1254234.0000001 , 1245663.0000001 ). This column > is not defined as 'primary key' or integer. > > I'm using version 2.8.14 and the weird thing is there is no problem when > I use LiteQuery which uses 2.8.12. That means, there is no problem with > my query. I also checked with version 2.8.17 and the problem still > exists. And yeah, at this time I'm not in a position to switch to > version 3. > > Is this a known isssue with sqlite version 2 ? Does anyone know what's > happening ? >
This is not an issue known to me. I do not know what is happening. Try using round() on the values. -- D. Richard Hipp <[EMAIL PROTECTED]>