Hi all,

> > We are about to make an integration, where the other part has numbers like
> >
> > 7,000,001,112,604,109,445
> >
> > which are to big to fit into an INTEGER.
> >
> > Would an BIGINT be able to hold this number?
>
> No. A 64-bit integer holds 18 digits plus a few, but
> not 19 digits numbers where the leading digit is a 7.

Yes, it can. BIGINT supports the range -9,223,372,036,854,775,808 .. 9,223,372,036,854,775,807, so any 19-digit number starting with 8 or less is safe in any case.

With INTEGER, the biggest value is a little over 2 billion (US billion, that is).

Paul Vinkenoog