[thelist] re: mysql - money format?

Tony Crockford tonyc at boldfish.co.uk
Thu Nov 14 14:18:01 CST 2002


> What type of data should I specify for a money (price) field? Double?
> I do want to add the values later.
>
> Tom

This would help:

http://www.mysql.com/doc/en/Column_types.html

I'd be inclined to go with decimal, simply because you can force that
two two places.

Disclaimer:
I am not an expert.. ;o)




More information about the thelist mailing list