Subject Re: [firebird-support] Using blobs on firebird
Author M Tuttle (KS)
Greetings Max,

> I am working on a document management program using firebird as a database
> 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 as I believe this
allows for searching on the BLOB fields.

Hope this is helpful.