> But you said "I have read all articles I've found on IBPhoenix and the
> Paul Beach
> Presentation he did at firebird conference 2003." so you already know
> everything -
> then just sit and write your own filter ;-)
> (Did you also read IB documentation ? There are some examples (in C).)

Completed :-)

I finished re-writing blob filter sample api9.c / api9.f and "zip blob
filter" sample found at ibphoenix website :

http://www.ibphoenix.com/main.nfs?a=ibphoenix&l=;PAGES;NAME='ibp_blob_filter
'

I did that with delphi using JvUIB port of the Firebird API.

Now I'm asking if it could be possible to do this, considerating the
following table definition :

CREATE TABLE BLOB_TEST (
BLB_ID INTEGER NOT NULL,
BLB_ZIP SUB_TYPE -2,
BLB_TEXT SUB_TYPE 1
);

With my test program I add a blob into blb_zip column asking the engine to
use the zip_filter to compress the datas. It works well.

Is there a way to ask the engine to use filter(s) while executing this
statement :

UPDATE blob_test SET
BLB_TEXT = BLB_ZIP;

i.e to decompress the contents of BLB_ZIP before storing the text as
uncompressed datas into blb_text.

I tested and that don't works. Maybe in PS/SQL ? Can this be a new "feature"
for furter versions of Firebird 1.5 ?

If somebody is interrested in my work, I hope it will be incorporated into
next release of JvUIB components set.

Regards,

Pierre Y.