meta data for this page
  •  

F_BLOBSAVE

function from adhoc

Entrypoint blob_save compatible with UTF-8

Inputs/Outputs

   Input     CSTRING(8191)     complete path with filename
             BLOB              BLOb to save
   Output    INTEGER           size of saved file in bytes

Output file system saves (binary)file from a BLOB into filesystem

Syntax

   TestSQL
   Windows: (please adapt your path and IDs)
   SELECT F_BLOBSAVE('c:\copy\textblob.txt', TEXTBLOB), F_BLOBSAVE('c:\copy\picture.png', BINAERBLOB) FROM BLOBTEST WHERE BLOBTESTID = 14
   Linux:(please adapt your path and IDs)
   SELECT F_BLOBSAVE('/daten/copy/textblob.txt', TEXTBLOB), F_BLOBSAVE('/daten/copy/picture.png', BINAERBLOB) FROM BLOBTEST WHERE BLOBTESTID = 14