meta data for this page
  •  

F_BLOBSIZE

compatibility to FreeUDFLib, FreeUDFLib AvERP, GrUDF

input/output-compatibility to rFunc (B_TOTAL_LENGTH)

Entrypoint blobsize compatible with UTF-8

Inputs/Outputs

   Input      BLOB        TextBLOb
   Output     INTEGER     For TextBLOb: returns the size/length (similar F_STRINGLENGTH)
                          For BinarBLOb: returns the size of file in byte

Syntax

   CRLF are countered as 2 characters
   TestSQL (to use with TestISO.GDB)
   For a TextBLOb:
   SELECT 50 AS ISCORRECT, F_BLOBSIZE(TEXTBLOB), F_STRINGLENGTH(F_BLOBASPCHAR(TEXTBLOB)) FROM BLOBTEST WHERE BLOBTESTID = 2;
   SELECT 0 AS ISCORRECT, F_BLOBSIZE(TEXTBLOB), F_STRINGLENGTH(F_BLOBASPCHAR(TEXTBLOB))
   FROM BLOBTEST WHERE BLOBTESTID = 11;
   SELECT NULL AS ISCORRECT, F_BLOBSIZE(TEXTBLOB), F_STRINGLENGTH(F_BLOBASPCHAR(TEXTBLOB))
   FROM BLOBTEST WHERE BLOBTESTID = 10;
   For a BinärBLOb:
   SELECT 1426 AS ISCORRECT, F_BLOBSIZE(BINAERBLOB) FROM BLOBTEST WHERE BLOBTESTID = 4;