Possibility of SQL full text queries against file images?

[dking513]

Hello,
I would like to be able to issue full text queries against the files stored in the vault database. This is typically done by enabling a full text index on an image field, and registering the appropriate IFilter for extraction of keyword information. It appears that file images are stored in the tblFileInfo table. I assume they are in a compressed format. Is this a proprietary format, or perhaps a standard one that I may be able to index with the appropriate IFilter? I understand that I may compromise the performance of Vault once I start mucking around in your database!
Thank you,
Dave King

[jclausius]

Dave:

If an application can convert the database image column using the VCDiff format ( RFC 3284 ) is registred against the column, you might be able to enable limited searching within SQL Server ( not MSDE ). However, most rows in the table are stored as "deltas" ( not the actual file ), so we have not explored what results the full text index may actually produce.

We have a feature request to enable a full text searching of a repository ( regardless of SQL Server or MSDE ). Would you like me to add your name to the list of users requesting the feature?

[dking513]

Yes, please add me to the list of users who would interested in the full text query feature.
Thanks,
Dave