F_UPC12

Entrypoint upc12 compatible with UTF-8

   Input      CSTRING(250)   number to check as string
   Output     CSTRING(12)     complete number include checkdigit

   Complete number include checkdigit. Spaces, hyphens and digits more than max. length are ignored.
   Test-SQL
   SELECT '12345670' AS ISCORRECT, F_GTIN8('1234567') FROM RDB$DATABASE;
   SELECT '123456789012' AS ISCORRECT, F_UPC12('12345678901') FROM RDB$DATABASE;
   SELECT '7622200004607' AS ISCORRECT, F_GTIN13('762220000460') FROM RDB$DATABASE;
   SELECT '01234567890128' AS ISCORRECT, F_GTIN14('0123456789012') FROM RDB$DATABASE;
   SELECT '012345678901234560' AS ISCORRECT, F_NVE18('01234567890123456') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_GTIN8(NULL') FROM RDB$DATABASE;

   nach oben • go top •
   Preliminary note to ISBN-Number from Wikipedia (http://en.wikipedia.org/wiki/ISBN):
   The International Standard Book Number (ISBN) is a unique, numerical commercial book identifier, based upon the 9-digit Standard Book Numbering (SBN) code created by Gordon Foster, now Emeritus Professor of Statistics at Trinity College, Dublin  for the booksellers and stationers W.H. Smith and others in 1966. The 10-digit International Standard Book Number (ISBN) format was developed by the International Organization for Standardization and published as an international standard, ISO 2108, 
   in 1970. (However, the 9-digit SBN code was used in the UK until 1974.) Currently, the ISO TC 46/SC 9 is responsible for the standard.
   Since 1 January 2007, International Standard Book Numbers have been of 13 digits, compatible with Bookland EAN-13s.
   For other forms of publications, like periodicals or music there are own number systems:
       - ISAN – International Standard Audiovisual Number
       - ISMN – Internationale Standard-Music-Number (for printed or digital musical notations)
       - ISRC – The International Standard Recording Code
       - ISRN – International Standard Technical Report Number
       - ISSN – International Standard Serial Number (for periodicals)
       - ISWC – International Standard Musical Work Code
   Publisher identification code numbers are unlikely to be the same in the "978" and "979" ISBNs, like-wise, there is no guarantee that language area code numbers will be the same. Moreover, the ten-digit ISBN check digit generally is not the same as the thirteen-digit ISBN check digit. Because the EAN/UCC-13 is part of the Global Trade Item Number (GTIN) system (that includes the EAN/UCC-14, the UPC-12, and the EAN-8), it is expected that ISBN-generating software should accommodate fourteen-digit ISBNs.