Subject Re: [firebird-support] searching a varchar(100) column
Author Ann W. Harrison
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,


Ann