meta data for this page
  •  

F_BLOBLOAD

function from adhoc

Entrypoint blob_load compatible with UTF-8

Inputs/Outputs

   Input      CSTRING(8191)      complete path with filename
   Output     BLOB               load (binary)File in a BLOB

Syntax

   TestSQL
   Windows: (please adapt your path and IDs)
   SELECT F_BLOBLOAD('C:\boot.ini') FROM RDB$DATABASE;
   INSERT INTO BLOBTEST (TEXTBLOB, BINAERBLOB) SELECT 'PNG-picture' || F_CRLF() || 'FreeAdhocUDF.png', F_BLOBLOAD('C:\copy\FreeAdhocUDF.png') FROM RDB$DATABASE;
   UPDATE BLOBTEST SET TEXTBLOB = 'PNG-picture' || F_CRLF() || 'firebird-logo-400.png', BINAERBLOB = F_BLOBLOAD('c:\copy\firebird-logo-400.png') WHERE BLOBTESTID = 14
   Linux:(please adapt your path and IDs)
   SELECT F_BLOBLOAD('/etc/passwd') FROM RDB$DATABASE;
   SELECT F_BLOBLOAD('/daten/copy/FreeAdhocUDF.png') FROM RDB$DATABASE;
   INSERT INTO BLOBTEST (TEXTBLOB, BINAERBLOB) SELECT 'PNG-picture' || F_CRLF() || 'FreeAdhocUDF.png', F_BLOBLOAD('/daten/copy/FreeAdhocUDF.png') FROM RDB$DATABASE;
   UPDATE BLOBTEST SET TEXTBLOB = 'PNG-picture' || F_CRLF() || 'firebird-logo-400.png', BINAERBLOB = F_BLOBLOAD('/daten/copy/firebird-logo-400.png') WHERE BLOBTESTID = 14