I check the datatype for the product, for the price is using float(4,2)
Today I read from this website
It said not to use float.
And I personal experience is
I set the datatype as float and I didn't set the Length/Values
What I was found is, when I enter record not .5 it unable to search it out,
for example, I insert a record is 1.5, I select the value, it able to come out, but if I insert a record is 35.9 , then I can't get any result.
I would like to ask professional PHP programmer, should we should float or not for currency?