Subject RE: [firebird-support] Re: NUMERIC and DECIMAL
Author Rick Debay
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-----
[] On Behalf Of zaher dirkey
Sent: Saturday, October 08, 2005 10:25 PM
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?


------------------------ Yahoo! Groups Sponsor --------------------~-->
Fair play? Video games influencing politics. Click and talk back!


Visit and click the Resources item on
the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at


Yahoo! Groups Links