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
For
tered is the value 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
Subj
loose
about 12 cents. Not big losses, but when dealing with financial accounting
it is generally an unacceptable inaccuracy.
Grant Q
-Original Message-
From: Mojtaba Faridzad [mailto:[EMAIL PROTECTED]
Sent: Monday, June 09, 2003 11:56 AM
To: [EMAIL PROTECTED]
Subject: money field
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
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL P
