meta data for this page
  •  

F_BLOBMAXSEGMENTLENGTH

compatibility to FreeUDFLib

input/output-compatibility to rFunc (B_MAX_SEGMENT)

Entrypoint blobmaxsegmentlength not compatible with UTF-8 - no UTF-8 function planed

Inputs/Outputs

   Input      BLOB        TextBLOb or BinärBLOb
   Output     INTEGER     Countered bytes of the largest BLOB-segment

Syntax

   TestSQL (to use with TestISO.GDB)
   For a TextBLOb:
   SELECT 16384 AS ISCORRECT, F_BLOBMAXSEGMENTLENGTH(TEXTBLOB) FROM BLOBTEST WHERE BLOBTESTID = 8;
   SELECT NULL AS ISCORRECT, F_BLOBMAXSEGMENTLENGTH(TEXTBLOB) FROM BLOBTEST WHERE BLOBTESTID = 10;
   For a BinärBLOb:
   SELECT 16384 AS ISCORRECT, F_BLOBMAXSEGMENTLENGTH(BINAERBLOB) FROM BLOBTEST WHERE BLOBTESTID = 7;