List:MySQL on Win32« Previous MessageNext Message »
From:Felix Geerinckx Date:October 7 2005 1:50pm
Subject:Re: UPDATE does round value automatically - is it an error?
View as plain text  
On 07/10/2005, "Vassilopulos, Georg" wrote:

> The Table is MyIsam and there is a Database field with Datatype float
> called "kasse_s"
> 
> The value of this field is 10323.2
> 
> I want to UPDATE this field to 10323.22
> 
> After the update which goes without errors the field value is still
> 10323.2 and not as I would expect 10323.22

10323.22 is beyond the precision of the FLOAT datatype. Use DOUBLE
instead.


-- 
felix
Thread
UPDATE does round value automatically - is it an error?Georg Vassilopulos7 Oct
  • Re: UPDATE does round value automatically - is it an error?Felix Geerinckx7 Oct
  • Re: UPDATE does round value automatically - is it an error?C.R. Vegelin7 Oct