File functions: with BLObs |
 |
F_BLOBLOAD |
function
from adhoc |
Entrypoint |
blob_load |
compatible with UTF-8 |
Input |
CSTRING(8191)
|
complete path with filename
|
Output |
BLOB |
load (binary)File in a BLOB
|
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
|
  |
F_BLOBSAVE |
function
from adhoc |
Entrypoint |
blob_save |
compatible with UTF-8 |
Input |
CSTRING(8191) BLOB
|
complete path with filename BLOb to save
|
Output |
INTEGER |
size of saved file in bytes |
Output file system | saves (binary)file from a BLOB into filesystem |
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
|
  |