Subject Re: Hex string literal, blob not supported for conversion?
Author Dmitry Yemanov
31.08.2015 15:03, Martijn Tonies wrote:
>
> 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?

X'10' means a binary string (char octets) but this is not a blob. AFAIU,
the char->blob conversion is impossible in this context.


Dmitry