Re: HTML word breaker
From: John Kane (jt-kane_at_comcast.net)
Date: 05/14/04
- Next message: Benoit: "Full Text Service not starting from EM"
- Previous message: John Kane: "Re: Attn Hillary - looking for searchpage1.htm"
- In reply to: vel ²: "Re: HTML word breaker"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 13 May 2004 18:59:01 -0700
VB,
In regards to #2, I forwarded to MS the suggestion to have TEXT and NTEXT be
FT Searchable in the same manner as IMAGE columns with a file extension for
HTML code as in SQL Server 7.0 the IMAGE FT Indexing was not supported. To
the best of my knowledge the DCR (Documented change request) was filed as a
possible enhancement for Yukon (SQL Server 2005) and it is a shame that MS
is not listening in on this thread...
While Hilary only suggested two alternatives (other than staying with
Verity), there is a pure T-SQL solution to this problem, that I was going to
write about in my book on Microsoft Search technologies, but alas this
effort has ended... If you're interested the 3rd option, feel free to email
me directly.
Regards,
John
"vel ²" <nospamvbrook@NTMLLC.com> wrote in message
news:#G#i6$ROEHA.540@TK2MSFTNGP11.phx.gbl...
> Thanks for advice but
>
> 1) is not an option
>
> 2) search column is not image but text type and SQL server 2000 supports
> only filtering of BLOB (IMAGE) type data not text.
>
> I cannot believe that it's impossible to assign some set of chars as word
> breaker.
>
> For me, if that's the case, Microsoft Full Text search is dead. Really I
> wanted to get rid of third party search engine(Verity).
>
> But looks like I have to stay with them.
>
> VB
>
> "Hilary Cotter" <hilaryk@att.net> wrote in message
> news:7652AFF1-0056-48C9-AE71-88A8BDE6AC67@microsoft.com...
> > you have two options,
> > 1) storing your data with all html tags removed
> > 2) adding a char(4) column to the table you are FTI, with a value of
.htm
> in it, and then using the defaultcolumntype parameter of
sp_fulltext_column
> to tell MSSearch to index this document as a html doc.
>
>
- Next message: Benoit: "Full Text Service not starting from EM"
- Previous message: John Kane: "Re: Attn Hillary - looking for searchpage1.htm"
- In reply to: vel ²: "Re: HTML word breaker"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
