Float doesn't go past 100

[ashraf02]

i have set my clothes price field to float datatype at(4,2) it doesn't let me exceed 100 it comes up with 99.99 i must be doin something stupid can some one please help.

[mwasif]

Run the following query and post the result here.
[CODE=mysql]SHOW CREATE TABLE tablename;[/CODE]

[ashraf02]

CREATE TABLE Clothes (
Clothes_ID int not null primary key auto_increment,
Type_ID int not null,
Clothes_Brand varchar (30) not null,
Clothes_Type varchar (80) not null,
Clothes_Colour varchar (30),
Clothes_Price float (4,2) not null,
Clothes_Image varchar (150),
Clothes_Descrip tion text);

[ronverdonk]

You defined it as 4 in total length of which 2 decimals, so 99.99 is the maximum.

MySQL allows a non-standard syntax: FLOAT(M,D) or REAL(M,D) or DOUBLE PRECISION(M,D). Here, “(M,D)” means than values can be stored with up to M digits in total, of which D digits may be after the decimal point

Ronald

[ashraf02]

Thanx ronald i get it now.

[ronverdonk]

Okay, see you next time.

Ronald