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

[Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]]

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