Best field type for currency (price of a product)

[sb44940]

Hello,

Just wondering what you guys the best SQL field type is to store a price?

I need to be able to display this price on a website and need to be able to order by it!

Just wondered what you guys would do?

Regards

Shaun

[Mez]

Take a look at http ://dev.mysql.com/doc/refman/5.0/en/numeric-types. html

[guelphdad]

Decimal. Double and Float, which I see too many people use, are subject to rounding errors.

[sb44940]

After reading through the link Mez provided I agree that Decimal would be the best!

But how do I display a decimal value as currency.

For example: 27995.00 needs to be displayed as £27,995.00!

Regards

Shaun

[r937]

For example: 27995.00 needs to be displayed as £27,995.00!

do the formatting in your front end application (php or whatever)

[sb44940]

Great!

Thanks again for your help there!

Regards

Shaun