Full Text Search on varbinary columns

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

duke - 24 Aug 2006 13:13 GMT

Hi,
I have installed SQL Server 2005 Express Edition with Advanced Services
and I tried to process a full-text search on a varbinary or image
column. I insert in this column ppt-files.
But it returns always 0 rows, although I searched some words that are
inserted in my ppt-files.
On text based columns it works well.

My question are:
-It is really possible to process a full-text search on a varbinary
column with this version of SQL Server(Express Edition with Advanced
Services)?
-If yes, what could be the problem?

Thanks in advance
duke

Reply to this Message

Hilary Cotter - 24 Aug 2006 13:40 GMT

It should be. Did you add a column which contains the document type ie
(.ppt)? And when you created your full-text index, did you reference this
document type column, ie

CREATE FULLTEXT INDEX ON MyTableName
(VarBinaryColumn TYPE COLUMN VarBinaryColumnExtension )
KEY INDEX index_name
-- Hilary CotterDirector of Text Mining and Database
StrategyRelevantNOISE.Com - Dedicated to mining blogs for business
intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Hi,
> I have installed SQL Server 2005 Express Edition with Advanced Services
[quoted text clipped - 12 lines]
> Thanks in advance
> duke

Reply to this Message

duke - 28 Aug 2006 12:19 GMT

Yes, I add a type column and I reference it in my full-text index.

With:

SELECT * FROM sys.fulltext_indexes JOIN sys.tables
ON sys.tables.object_id = sys.fulltext_indexes.object_id
WHERE sys.tables.name = 'tblTest'

I can see my full-text index. But it returns 0 rows if I serach a known
word.
I tried with ppt-files and word-files. I have always the same result =>
0 rows.

What could be the problem?

Thanks for help.

Hilary Cotter schrieb:

> It should be. Did you add a column which contains the document type ie
> (.ppt)? And when you created your full-text index, did you reference this
[quoted text clipped - 31 lines]
> > Thanks in advance
> > duke

Reply to this Message

Hilary Cotter - 28 Aug 2006 13:27 GMT

can you query this for me please?

SELECT * FROM sys.fulltext_indexes where object_name(ID)='tblTest'

and post the results back here?

Signature

Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Yes, I add a type column and I reference it in my full-text index.
>
[quoted text clipped - 50 lines]
>> > Thanks in advance
>> > duke

Reply to this Message