Hi Lester,

> >>It was my understanding that a Blob Filter would process the data as it
> >>is written into the Blob, compress it or encode it, and then uncompress
> >>or unencode when the blob is read out.
> >>
> >>This is supposed to be a way to make sensitive data more secure, so that
> >>without the filter, a copy of the database would be of little use.
> >>
> >>Have I got it wrong? Which is quite possible :)
> >
> > Well, last year in Fulda, Paul did a talk on an example BLOB-filter -
> > however, it seems they can be used only in embedded SQL.
> >
> > What it comes down to, is that you need to _ask_ for data in a specific
> > sub-type. Next, Firebird will use the BLOB filter to convert the data
> > from the stored format to the asked-for format. However, when using
> > plain SQL, you cannot do that.
>
> This will probably show my ignorance :)
> Is the implication here that one could use them with Stored Procedures?
> SO the stored procedure could input and return the correct result?

Not that I can think of... then again - I'm not a wizard with
BLOB filters in any way :-) ... This was only my understanding
from last year.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com