Re: UPDATE does round value automatically - is it an error?

[Felix Geerinckx]

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