Subject | Re: [firebird-support] searching a varchar(100) column |
---|---|
Author | Ann W. Harrison |
Post date | 2005-05-01T03:51:16Z |
David Johnson wrote:
Cheers,
Ann
>Count your fingers again... int gives you a full 9 digits... plus some..
> 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.
Cheers,
Ann