Fulltext and text type fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tshad - 03 Mar 2006 00:01 GMT

Does Fulltext work on text fields?

I thought it didnt, but I just changed my varChar(8000) field to text and it
still seemed to work !

Thanks,

Tom

Reply to this Message

Hilary Cotter - 03 Mar 2006 10:25 GMT

It works on text, char, nchar, varchar, nvarchar, image (with the document
type column containing the extension the file would have if it was in the
file system and the ifilter is in the os and SQL is configured to load it),
and varbinary(max) (with the document type column containing the extension
the file would have if it was in the file system and the ifilter is in the
os and SQL is configured to load it).

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

> Does Fulltext work on text fields?
>
[quoted text clipped - 4 lines]
>
> Tom

Reply to this Message

Simon Sabin - 26 Apr 2006 12:51 GMT

Yep it does.

> Does Fulltext work on text fields?
>
[quoted text clipped - 4 lines]
>
> Tom

Reply to this Message