money field

2003-06-09 Thread Mojtaba Faridzad
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

RE: money field

2003-06-09 Thread Quinlan, Grant
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

Re: money field

2003-06-09 Thread Becoming Digital
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

Re: money field

2003-06-09 Thread gerald_clark
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