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

2015-08-31 Thread 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: > “ fea

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

2015-08-31 Thread 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

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

2015-08-31 Thread 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support]
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 suppor

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

2015-08-31 Thread 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support]
Hello Dmitry, >> 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) >> ); >> >

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

2015-08-31 Thread Lester Caine les...@lsces.co.uk [firebird-support]
On 31/08/15 16:07, 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support] wrote: > Nevertheless, the parameter is BLOB. Why is one blob conversion supported, > but an other, that looks the same to the user, fails? Martijn ... I always thought that the 'blob' in a function h

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

2015-08-31 Thread 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support]
Hello Lester, >m.ton...@upscene.com [firebird-support] wrote: >> Nevertheless, the parameter is BLOB. Why is one blob conversion >> supported, >> but an other, that looks the same to the user, fails? > >Martijn ... I always thought that the 'blob' in a function had to be an >existing blob element