Subject RE: [Firebird-Architect] NUMERIC vs DECIMAL
Author Pavel Cisar
Claudio,

On 6 Aug 2003 at 6:56, Claudio Valderrama C. wrote:

> - Both numeric and decimal behave the same. Numeric isn't SQL compliant
> currently.
>
> - For both dialects, being "p" the precision, the internal storage is:
> 1 <= p <= 4 => smallint

Are you sure ? I'd swear that decimal is stored as INTEGER (32bit) as
documented. I checked that some time ago on FB 1.0.2 (? don't remember,
but I'd also swear this apply to both dialects). But my memory is often
lousy, so the reality check is needed.

Best regards

Pavel Cisar
http://www.ibphoenix.com
For all your upto date Firebird and
InterBase information