Subject | Re: [firebird-support] searching a varchar(100) column |
---|---|
Author | David Johnson |
Post date | 2005-05-01T13:49:54Z |
On Sun, 2005-05-01 at 08:21 -0500, David Johnson wrote:
Any 9 digit number will fit in a 32 bit int, which is 10 digits of
precision.
Back to bed for me, I think.
> On Sat, 2005-04-30 at 23:51 -0400, Ann W. Harrison wrote:Okay ... I admit it. I can't count. That's why I use a computer.
> > 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.
>
Any 9 digit number will fit in a 32 bit int, which is 10 digits of
precision.
Back to bed for me, I think.