""Hellen Huang"" <hellen@...> wrote in message
news:000c01c1bff9$9c78aa00$3a50a8c0@......

> Hi All,
>
> I rather confused about numeric data type, 'cause I often received error

"Numeric overflow"

Numeric(p,s) is a SQL type.
"Numeric overflow" is a generic message for all values that are numbers, not
in direct connection with SQL's "numeric" data type.
Numeric overflow can happen with integers or floating point, although with
the latter a typical message carries the "floating" word in it.

In dialect 1, numeric(p,s) is implemented internally as:
p < 5 => short int
5 <= p < 10 => int
p >= 10 => double precision

In dialect 3,
p >= 10 is implemented internally as int64.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing