Don't worry about actual DB implementation, except to know how it might
impact you negatively. Code to best practices and standards.

Is your data confined to a certain precision? If so use Numeric as it
is not allowed to have a greater precision that its definition. If your
data can have a greater precision, then use Decimal. It's precision is
allowed to grow to whatever the underlying implementation is.

On Firebird, you'll have to constrain the Numeric yourself by adding a
CHECK constraint.

Rick DeBay

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of zaher dirkey
Sent: Saturday, October 08, 2005 10:25 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: NUMERIC and DECIMAL

Let see, i will ask again:
When i must use NUMERIC or must use DECIMAL, what is the real
differents, in numbers and examples if you have time to it?

thanks





------------------------ Yahoo! Groups Sponsor --------------------~-->
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/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