I've never heard anyone who knows what they are talking about, suggest double precision. It's only place would be as an intermediary value in a stored procedure.
If you want to constrain the monetary value to a certain precision, use Numeric. If you want it to be able to exceed the precision, use Decimal.
FB doesn't support these distinctions, but I feel it's important to try to do the correct thing.
I also use domains that wrap these base data types, and add such constraints in to the domain.

Rick DeBay

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Kevin
Sent: Friday, May 19, 2006 3:40 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Money data type

I've read several articles about what the best data type is in Firebird to store money. Some say Decimal, others Numeric, and yet others Double Precision.

Many of these articles are quite old (some 5+ years), so I am interested to see if anything on this topic has changed recently and what is currently recommended. Also, has Firebird 2.0 introduced anything new to consider on this topic?

Thanks in advance...





------------------------ Yahoo! Groups Sponsor --------------------~--> Everything you need is one click away.  Make Yahoo! your home page now.
http://us.click.yahoo.com/AHchtC/4FxNAA/yQLSAA/67folB/TM
--------------------------------------------------------------------~->

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links