From: "Sandor Szollosi" <ssani@...>

> Is there any documentation about differences between numeric and
> decimal datatypes.
> Data Definition Guide gives datails abuot them but I can't see
> differences right enough.
> If it possible to explain briefly help me folks pls.

SQL standard requires that
NUMERIC stores numbers with specified precision, while
DECIMAL stores numbers with precision equal or greater that specified one.

IB/FB does not distinguish these types (regarding precision);
both types effectively behaves like DECIMAL.

(e.g. you can store 1234567.89 into NUMERIC(6,2))


Ivan Prenosil
[ Looking for a job: InterBase - Firebird - Delphi - C - fulltext db - and more ... ]
Ivan.Prenosil@...
http://www.volny.cz/iprenosil/interbase