[firebird-support] Hex string literal, blob not supported for conversion?

Mon, 31 Aug 2015 05:03:50 -0700 

Hi all,

I wonder, should this be possible:
select f_blobsize(X'10')
from rdb$database

DECLARE EXTERNAL FUNCTION F_BLOBSIZE
    BLOB
    RETURNS INTEGER FREE_IT
    ENTRY_POINT 'blobsize' MODULE_NAME 'FreeAdhocUDF';

I’m getting this error:
“ feature is not supported BLOB and array data types are not supported for 
conversion operation “


But as far as I can see, X’10’ returns a binary string, a blob?

Firebird 2.5.

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!

Reply via email to