look at all this numbers in mysql!

i have a problem with mysql her. had a ms-access database before, but i need all data in mysql now because an access .mdb-file is not the best choice for a shop system.
i found a nice tool (navicat) to export this whole .mdb to mysql without any accident.
now i have this new field with the content of an item, which can be anything between 0.0012 and 900 and im not sure about the right datatype. its "decimal" at the moment (length 8, zerofill off, unsigned on, null allowed), but it "zerofills" the whole number now, so i get results like "0.50000" (0.5 is what i need).
so whats the right datatype for this?

 

go with a double,
if the range can be anywhere from 0.0012 - 900, then



datatype: FLOAT

 

I'd keep it as decimal, or you could try float if you want. And why does it matter if it's 0.50000 or 0.5 they are equivalent.

 

because "0.50000 l" dosnt looks very professional on a shopping cart. is there some kind of string function to cut the last zeros?

 

number_format ($number, 2);

PHP:

Which will give you 0.50 which looks better than 0.5

 

Exam, quick question on the DECIMAL type.

I was under the impression that Decimal was a fixed decimal point and stored as a string. Wouldn't that mean that if specified lets say 5,2 each number would have to be 234*.11 (at a max length)?

 

Yes, you've pretty much got it: