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

[Jorge Bastos]

show the table structure



----- Original Message ----- 
From: "Vassilopulos, Georg" <georg@stripped>
To: <win32@stripped>
Sent: Friday, October 07, 2005 1:07 PM
Subject: UPDATE does round value automatically - is it an error?


Hello!

 

I use Mysql Server: 4.1.14-max on Windows Standard Server 2003

 

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

 

What mistake I am making?

How do I solve my problem?

 

Thank you for your help!

 

Sincerely

Georg