Hi all, I’ve got this following problem and example:
SET TERM ^^ ; create PROCEDURE DEBUG_TEST returns ( C BLOB SUB_TYPE 0, M2 Numeric(18,0), I2 VarChar(10)) AS declare variable i varchar(4) = X'4131'; declare variable m numeric(18) = 0x2121; declare variable b blob; begin c = 0x40; m2 = m; i2 = i; suspend; end ^^ SET TERM ; ^^ As you can see, output BLOB “c” gets a binary value of 0x40, as per hex literal in Firebird 2.5, a single byte. However, when I now query the routine: select * from debug_test; The blob returned is: 64 That is, ‘64’ in characters! Two characters! I’ve verified this in Database Workbench, BLOB Editor for hex values, returned is: 3634 And using f_blobsize function in FreeAdhocUDF, which returns a size of “2”. Any clue why this happens? With regards, Martijn Tonies Upscene Productions http://www.upscene.com Download Database Workbench for Oracle, MS SQL Server, Sybase SQL Anywhere, MySQL, InterBase, NexusDB and Firebird!