Aahh..that helps. Thanks!

Regards
Kenneth

----- Original Message -----
From: "Geoff Worboys" <geoff@...>
To: "Kenneth Foo" <ib-support@yahoogroups.com>
Sent: Friday, January 25, 2002 4:47 PM
Subject: Re: [ib-support] int64 (numeric(18,0)) 64-bit numeric range


> > But with a max of length of 18 digits using NUMERIC(18,0), it's
> > impossible to even have a positive value of 2^60.
>
> The limits of a signed 64bit integer are:
> -9223372036854775808 to +9223372036854775807
>
> You can store any of the above range in a NUMERIC(18,0) column - not
> that I've been through and checked everyone :-) but the limits work.
>
> IB/FB does not validate the defined precision. The only validation
> is whether the value will fit within the storage size allocated
> for that precision - 2 bytes for NUMERIC(1..4), 4 bytes for
> NUMERIC(5..9) and 8 bytes for NUMERIC(10..18).
>
> If you wish to limit inputs to the defined precision you have to apply
> appropriate constraints against the domain.
>
> hth
>
> --
> Geoff Worboys
> Telesis Computing
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>