Subject Re: [firebird-support] BLOB Filter
Author Ivan Prenosil
> I've lots of questions obout blob filters. I have read all articles I've
> found on IBPhoenix and the Paul Beach Presentation he did at firebird
> conference 2003.
>
> Is there some sample of compiled BLOB filters ?
> Can I write one with Delphi ?

Sure, it is just DLL library.

> What happens when I store datas to the database ? Is the filter used
> automatically by the engine since it has been declared ?

No, you have to explicitely ask the server to use the filter.
(by supplying appropriate Blob Parameter Block to isc_open_blob2()
or isc_create_blob2() functions)


> Imagine I would
> like to use a "zip" filter for text blobs. Wich type of blob should I
> declare for the field in my table ?

Pick any negative number you wish (between -32k and -1)

Ivan