Subject | Integer vs. BigInt |
---|---|
Author | mivi71dk |
Post date | 2011-01-07T10:22:05Z |
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
7000001112604109445
which are to big to fit into an INTEGER.
Would an BIGINT be able to hold this number?
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?
Michael
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
7000001112604109445
which are to big to fit into an INTEGER.
Would an BIGINT be able to hold this number?
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?
Michael