storing prices

[jimfog]

What do you think is the best column type for storing prices?

[LAs]

What kind of question is that?!

 

It depends, how big your price value could be.

 

Use float, in that case, you will be able to hold price value with cents.

[birbal]

for storing currency best to use decimal. float has issues to loss data in arithmetic operation.

[thescientist]

What kind of question is that?!

 

that's a perfectly legitimate question. No need to be condescending.

 

I also agree with birbal, I use decimal to store currency values. usually something like (10,2), but should be changed to best reflect the requirements of your application.

[jimfog]

that's a perfectly legitimate question. No need to be condescending.

 

I TOTALLY AGREE...THANKS

[jimfog]

Ι used decimal(3.2) but I noticed that it cannot accept 10 or 20 for example....why that? I thought the 3 means 3 digit number MAX.

 

I receive a message saying out of range value....

[birbal]

First param is total digits including integer part and fraction part. Second one is number of fraction part.So (3,2) can be max to 9.99