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

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

31.08.2015 17:31, Martijn Tonies wrote:
>
> This works:
>
> CREATE TABLE BMP_BLOBS
> (
>    ID                   INTEGER         NOT NULL,
>    BMP                     BLOB SUB_TYPE 0 SEGMENT SIZE 80,
>    "COMMENT"              VARCHAR(    20)  COLLATE ISO8859_1,
> CONSTRAINT PK_BMP_BLOBS PRIMARY KEY (ID)
> );
>
> insert into BMP_BLOBS
> values (-1, X'101010', 'test')
>
> How is the declared function any different?

UDFs were always quite limited.


Dmitry