Greetings Max,

> I am working on a document management program using firebird as a database

engine.

> My questions are :

> 1. Is it ok to store the docs (text files) in blobs or not ? The database

could become huge in size... or should I store the docs as files and have
only the path and file names in firebird database?

The best way would be the to store the docs as files and reference them via
a path and filename.

> 2. Where can I find some info regarding full text search on blob fields ?

Searching the database for docs having the words I'm searching for should be
fast enough...

Check out this link http://www.textolution.com/ftsib.asp as I believe this
allows for searching on the BLOB fields.

Hope this is helpful.

Mike