meta data for this page
  •  

F_BLOBCOMPARE

compatibility to FreeUDFLib, GrUDF (BLOBICOMP)

Entrypoint blobcompare compatible with UTF-8

Inputs/Outputs

   Input     BLOB       BLOB 1
             BLOB       BLOB 2
   Output    INTEGER    1 = identically, 0 = not identically

Syntax

   TestSQL (to use with TestISO.GDB)
   SELECT 1 AS ISCORRECT, F_BLOBCOMPARE(TEXTBLOB, TEXTBLOB) FROM BLOBTEST WHERE BLOBTESTID = 3;
   SELECT 0 AS ISCORRECT, F_BLOBCOMPARE(TEXTBLOB, (SELECT TEXTBLOB FROM BLOBTEST WHERE BLOBTESTID = 2)) FROM BLOBTEST WHERE BLOBTESTID = 3;
   SELECT NULL AS ISCORRECT, F_BLOBCOMPARE(TEXTBLOB, TEXTBLOB) FROM BLOBTEST WHERE BLOBTESTID = 10;