From: | mdean <mdean(at)xn1(dot)com> |
---|---|
To: | Jeremy Kronuz <kronuz(at)hotmail(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: ISBN/ISSN/ISMN/EAN13 module |
Date: | 2006-08-24 00:24:04 |
Message-ID: | 44ECF1A4.9000801@xn1.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Jeremy Kronuz wrote:
>
> > Michael wrote:
> > I do hope that your algorithm for generating 13 digits from 10 has been
> > validated with isbn.org, since all the check digits will change. I
> > believe it is crucial for postgresql to generate isbn codes in both 10
> > and 13 digits
>
> Indeed now that see the module it's finally close to be accepted as an
> official module, I'm verifying my algorithm against the one in the
> ISBN User Manual and all the current information I can get my hands
> into (I first created the module a couple years ago, and there wasn't
> as much information back then.)
>
> The module internally keeps all the numbers in EAN13 mode, and it only
> converts the numbers to ISBN when required or needed by the selected
> data type.
>
> > and in the two separate ways required of publishers on
> > their bar codes, with just the 10 digit input. This is just a special
> > case for the overall classification system, so the initial 3 digit code
> > for book publishers should not be hard wired.
>
> I got lost in what you said here, could you please be more specific?
> what is that about the initial 3 digit code you're mentioning?
> do you mean "the two separate ways", you mean both ISBN and ISBN13 as in:
>
> ISBN-13: 978-1-873671-00-9
>
> ISBN-10: 1-873671-00-8
>
> ?
>
> Shortly, I'll be further improving the performance and doing some
> tweaking in other areas, as well as updating the ISBN hyphenation
> ranges and probably adding UPC support.
> I'm still not sure if to include hyphenations in the EAN13 codes as it
> seems it's not part of the standard, thus 0036000291452 and
> 9781873671009 would be to examples of how the EAN13 numbers would show
> without hyphenation....
>
> Thanks for your concerns,
> Kronuz.
>
> "Fools rush in where fools have been before" - Unknown
>
>
> ------------------------------------------------------------------------
> Get the new Windows Live Messenger! Try it!
> <http://get.live.com/messenger/overview>
the 978 is the worldwide classification for book publishers. There is a
complete schedule of 3 digit prefixes for all other types of products in
the world, and it syncs withbthe NAIAC
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.11.5/425 - Release Date: 8/22/2006
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-08-24 01:22:39 | Re: Merge join performance |
Previous Message | Tom Lane | 2006-08-23 22:52:00 | Re: invalid byte sequence ? |