On 1/7/2011 5:22 AM, mivi71dk wrote:

> Hi
>
> We have come into a little problem here.
> Our DB i in SQL Dialect 1.
> We have a number in the system which is defined as an INTEGER.
>
> 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.

>
> Is so - We would have to convert the DB to dialect 3, which I suppose is done through an backup/restore cycle.
> Hereafter I would have to convert the field from INTEGER to BIGINT.
> Would there be a problem here, if the field is being referenced a lot of places?

There's a special dialect 2 which diagnoses database features that are
different between dialect 1 and dialect 3. The conversion may well not
be as simple as a backup and restore, unfortunately.

Best regards,

Ann