Subject RE: [firebird-support] searching a varchar(100) column
Author Alan McDonald
> On Sat, 2005-04-30 at 23:51 -0400, Ann W. Harrison wrote:
> > 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.
>

Integer - 32 bit: value range -2,147,483,648 to 2,147,483,648 i.e. total
4,294,967,296

10 digits

Alan