Log in

No account? Create an account
Off in the distance
my journal
May 2016

The Bellinghman
Date: 2006-05-24 18:07
Subject: Fun for book sellers and publishers
Security: Public
Oh, fun.

I've just spotted some work I need to get done in the next 7 months. 10 digit ISBNs are being phased out, in favour of ISBN-13s.

Admittedly, it will simplify things, since the ISBN-13s will initially have the same 978 prefix, and the same check digit calculation, as is currently used in the barcodes, thereby meaning that the ISBN above the barcode and the number encoded in the barcode are the same.

And in a few years, they'll start using the 979 prefix, too, doubling the currently available number space.

Looks like Amazon haven't caught up with this one yet.
Post A Comment | 3 Comments | | Flag | Link

User: vatine
Date: 2006-05-24 21:38 (UTC)
Subject: (no subject)
*phew* I seem to be sufficiently future-proofed!

mysql> describe book;
| Field     | Type        | Null | Key | Default | Extra          |
| id        | int(11)     | NO   | PRI | NULL    | auto_increment |
| publisher | int(11)     | YES  |     | NULL    |                |
| name      | varchar(90) | YES  |     | NULL    |                |
| isbn      | varchar(32) | YES  |     | NULL    |                |
| format    | int(11)     | YES  |     | NULL    |                |
| category  | varchar(5)  | YES  |     | NULL    |                |
6 rows in set (0.18 sec)

Well, apart from using MySQL, that is. I think I'll manage tio stick well under 10^11 books at home 9likewise, I believe those less than 10^11 books will have at least a few common publishers). I still have to update the ISBN pretty-printing routines, but that boils down to manipulating a table and shouldn't be TOO harsh.
Reply | Thread | Link

The Bellinghman
User: bellinghman
Date: 2006-05-25 09:12 (UTC)
Subject: (no subject)
You expect the ISBN range to become such that you need 32 digits?

I also like the way the publisher field uses 11 digits, when the world population is less that 10^10.
Reply | Parent | Thread | Link

User: vatine
Date: 2006-05-25 23:43 (UTC)
Subject: (no subject)
I don't expect it to. I expect to NEVER have to change that schema, even if we suddenly find ourself integrating our book-publishing industry book ID scheme with that of eth Net Of A Million Lies. I should be good for the next 6-or-so increases in ISBN length...
Reply | Parent | Thread | Link