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
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
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