Subject | Re: NUMERIC and DECIMAL |
---|---|
Author | Adam |
Post date | 2005-10-04T00:25:44Z |
--- In firebird-support@yahoogroups.com, "zaher dirkey" <zaher@d...>
wrote:
etc, so what are you trying to store?
Numeric(5,2) would be stored internally as integer in dialect 1 & 3.
Decimal(3,2) would be stored internally as a smallint in dialect 1 & 3.
So I don't imagine they are equivalent. That said, they may equally
serve your requirement.
Adam
wrote:
> Is numeric(5, 2) equal to decimal(3, 2)If you have The Firebird Book, pg 132-135. It depends on the dialect
> or what the deff between NUMERIC and DECIMAL
etc, so what are you trying to store?
Numeric(5,2) would be stored internally as integer in dialect 1 & 3.
Decimal(3,2) would be stored internally as a smallint in dialect 1 & 3.
So I don't imagine they are equivalent. That said, they may equally
serve your requirement.
Adam