Entrypoint blobsubstr not compatible with UTF-8 - use U_BLOBSUBSTR
Entrypoint u_blobsubstr compatible with UTF-8
Input BLOB TextBLOb (in which you are looking for the string from parameter 2) CSTRING(1024) String (you are looking for in the BLOb) Output INTEGER position in the BLOb where the string starts
Counting starts with 0. TestSQL (to use with TestISO.GDB) SELECT 4 AS ISCORRECT, F_BLOBSUBSTR(TEXTBLOB, 'einzeiliger') FROM BLOBTEST WHERE BLOBTESTID = 1; SELECT NULL AS ISCORRECT, F_BLOBSUBSTR(TEXTBLOB, NULL) FROM BLOBTEST WHERE BLOBTESTID = 10;