Hi,
i just took one of my books (1/7, yes not so much) and
analysed ISBN number..
Here it is: '975-316-258-8'
What will we do now?
1- hashing??? :)
2- illegal-missing entry to database?
3- field type chancing?
...

I'm agree with Helen.
I prefer integer or bigint IDs too.
ISBN is out of our control and it is a data like title.
No one guarentee its uniqueness and honesty like NIC#(MAC)
But ID is not a data. It is for to internal usage of our system.
There can be alot of support tables too, ISBN has more cost and
risks.

Regards,

Ali

--- In firebird-support@yahoogroups.com, "Ann W. Harrison"
<aharrison@i...> wrote:

> David Johnson wrote:
> >>
> >>Count your fingers again... int gives you a full 9 digits...

plus some..

> >>
> > 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.
>
> No, but a 32 bit integer holds values up to 4,294,967,295, which

is 9

> full digits plus .4294967295 of the tenth digit.
>
>
> Cheers,
>
>
> Ann
>
>
>
> >