Subject | Re: Hex string literal, blob not supported for conversion? |
---|---|
Author | Dmitry Yemanov |
Post date | 2015-08-31T15:03:20Z |
31.08.2015 17:31, Martijn Tonies wrote:
Dmitry
>UDFs were always quite limited.
> 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?
Dmitry