Hello Dmitry,

>> 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.

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?


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!