Subject | How to use blob filter |
---|---|
Author | Falko |
Post date | 2007-12-07T10:13:11Z |
Hi,
What i want is:
-automatically compress data when written to a specific blob column
via insert/update
-automatically decompress data of a blob column when selecting via a
select statement
What i did until now is:
-writing a dll which implements the blob filter (one for compressing
and one for decompressing)
-put the dll in udf folder of firebird (1.5.4)
-registering the bob filter with declare statement
What i could'nt get to work is:
-invoking the filters via sql or ibobjects-api or firebird-api
My questions:
1) is there a way using blob filters in sql statements?
2) how can i work with blob filters in ibobjects?
3) can i use blob filters in stored procedures? if so: what is the syntax?
best regards
falko :-)
What i want is:
-automatically compress data when written to a specific blob column
via insert/update
-automatically decompress data of a blob column when selecting via a
select statement
What i did until now is:
-writing a dll which implements the blob filter (one for compressing
and one for decompressing)
-put the dll in udf folder of firebird (1.5.4)
-registering the bob filter with declare statement
What i could'nt get to work is:
-invoking the filters via sql or ibobjects-api or firebird-api
My questions:
1) is there a way using blob filters in sql statements?
2) how can i work with blob filters in ibobjects?
3) can i use blob filters in stored procedures? if so: what is the syntax?
best regards
falko :-)