Piotr Pokora <[EMAIL PROTECTED]> wrote: > > > DB: 80.3, Midgard value: 80,300003 > > > DB: 1736.40649, Midgard value: 1736.406494 > > > > > > The dbtype of the property is double, the type is float. The same thing > > > happens when both dbtype and type are set to float. Plus, it happens > > > with straight Midgard objects (on 1.8.4, PHP5.2, Debian Testing and > > > openSuse 10.2), i.e. it doesn't seem to have anything to do with MidCOM. > > Can you describe table? > Did you try to debug queries to see if value used in SQL is correct?
Quote from MySQL docs ( http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html ): "For example, a column defined as FLOAT(7,4) will look like -999.9999 when displayed. MySQL performs rounding when storing values, so if you insert 999.00009 into a FLOAT(7,4) column, the approximate result is 999.0001." Can you also try to alter table so it should modify this column to FLOAT(7,7) ? Piotras _______________________________________________ user mailing list [email protected] http://lists.midgard-project.org/mailman/listinfo/user
