Subject | RE: [firebird-support] searching a varchar(100) column |
---|---|
Author | Alan McDonald |
Post date | 2005-05-01T13:33:36Z |
> On Sat, 2005-04-30 at 23:51 -0400, Ann W. Harrison wrote:Integer - 32 bit: value range -2,147,483,648 to 2,147,483,648 i.e. total
> > David Johnson wrote:
> > >
> > > The 9 _digit_ ISBN can be converted to a BigInt before storage. Strip
> > > out the hyphens and it is simply a piece of numeric data. I
> would still
> > > make it a BigInt since INT only gets you into the 4xx,xxx,xxx
> range in 9
> > > digit numbers.
> >
> > Count your fingers again... int gives you a full 9 digits...
> plus some..
> >
> >
> > Cheers,
>
> I plead exhaustion ... just chased the kids all day at the zoo.
>
> I was under the impression that Int was a 32 bit platform-native
> integer. I must be mistaken.
>
4,294,967,296
10 digits
Alan