I would use Decimal (12,2). A Float may be smaller, but only because it
rounds off the last several digits of large values. A single-precision float
uses 23 bits for storing digits, meaning that for values over 8,388,607 you
are loosing pennies. When storing a value around 100 Million you would
stored.
The 4-byte storage overhead is easily justified by this.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: Quinlan, Grant [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, 09 June, 2003 15:16
Subject: RE: money field
I would use Decimal (12,2
I use Decimal, because I like my money calculations to be correct.
Mojtaba Faridzad wrote:
Hi,
Which type do you usually use to keep money values? Decimal (12,2) or Float?
to keep the first one, system takes 12 bytes but for the second one, 8
bytes.
Thanks
--
MySQL General Mailing List