UPDATE does round value automatically - is it an error?

[Georg Vassilopulos]

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