Money type

[esm]

I know this is a mysql question but ...

what type should be used when creating a money field?

[pyro]

I'm not a mySQL expert by any means, but I would be inclined to go with decimal, as you can set the number of digits after the decimal point. Take a look at http://www.mysql.com/doc/en/Numeric_types.html