meta data for this page
  •  

F_ISBN13CHECK

function from adhoc

Entrypoint isbn13check compatible with UTF-8

Inputs/Outputs

   Input      CSTRING(250)     number to check as string
   Output     INTEGER          checkdigit from input

F_ISBN13

function from adhoc

Entrypoint isbn13 compatible with UTF-8

Inputs/Outputs

   Input      CSTRING(250)     number to check as string
   Output     CSTRING(17)      complete, formated ISBN-13 number include checkdigit

Syntax

   Fixed length of 13 characters (with hyphens 17). Allowed characters are 0-9, all other characters and all characters more than length 13 will be taken away.
   Test-SQL
   SELECT 6 AS ISCORRECT, F_ISBN13CHECK('978-3-88229-192') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_ISBN13CHECK(NULL) FROM RDB$DATABASE;
   SELECT '978-3-88229-192-6' AS ISCORRECT, F_ISBN13('978-3-88229-192') FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_ISBN13(NULL) FROM RDB$DATABASE;