meta data for this page
  •  

F_BLOBREPLACESTRING

function from adhoc

Entrypoint blobreplacestring not compatible with UTF-8 - use U_BLOBREPLACESTRING

U_BLOBREPLACESTRING

function from adhoc

Entrypoint u_blobreplacestring compatible with UTF-8

Inputs/Outputs

   Input     BLOB             TextBLOb to be modified by replacing a string
             CSTRING(254)     the string to be replaced in BLOb
             CSTRING(254)     new string
             INTEGER          0 = just replace the first appearance, 1 = replace all appearance
             INTEGER          0 = case sensitive, 1 = not case sensitive
   Output    BLOB             TextBLOb with replaced one/all character strings fromParameter 2 of the BLOB 
                              by the character string from Parameter 3

—-

Syntax

   TestSQL (to use with TestISO.GDB)
   SELECT 'vier einzeiliger TextBLOb' AS ISCORRECT, F_BLOBREPLACESTRING(TEXTBLOB, 'ein', 'vier', 0, 0) 
   FROM BLOBTEST WHERE BLOBTESTID = 1;
   SELECT 'vier vierzeiliger TextBLOb' AS ISCORRECT, F_BLOBREPLACESTRING(TEXTBLOB, 'ein', 'vier', 1, 0) 
   FROM BLOBTEST WHERE BLOBTESTID = 1;