MySQL Forums
Forum List  »  InnoDB

float(3,2) max value 9.99 ??
Posted by: Ronen Siboni
Date: May 07, 2005 09:25PM

Hello people,

I have a MySQL table structured:
smallint(5), varchar(50), float (3,2), float(3,2), float (3,2), float(3,2)

It all used to work fine until recently all the float fields does not accept any number above 9.99. If I enter 10.2 for example, the next query shows 9.99. This is only for new records, existing records show correct numbers.

I searched the net and it seems MySQL will do that if the number exceeds the limit, but this is not the case here.

Any idea?


Options: ReplyQuote

Written By
float(3,2) max value 9.99 ??
May 07, 2005 09:25PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.