Re: SQL Server Html Search Question

From: GitarJake (wiekiewatchee_at_spamkiller.net)
Date: 03/17/04 

Date: Wed, 17 Mar 2004 11:10:02 -0500

"Hilary Cotter" <hilaryk@att.net> wrote in message
news:u9MAEXCDEHA.2404@TK2MSFTNGP11.phx.gbl...

> It sounds like you don't have SQL FTS installed on your local machine. For
> SQL Server 7 you have to re-run setup, IIRC.

This is Sql 7 Desktop. I don't even get a choice for FTI or MS Search in
setup.

> BTW - indexing image data types are not supported using SQL 7.

Good to know in advance! However, the html issue is with Sql 2000 Standard
on Win 2000 Server.

Question: Would there be any unpleasant FTI issues with storing
HTML-Unicode content as you described earlier? Ie: Japanese or Chinese
characters with their appropriate word breakers.

"....to have your html content indexed withough the html formatting tags,
you need to store your documents in an image data type column. then you have
to add a char or varchar(4) column to your table, and update this column to
have a value of .htm. Then you need to use the SQL FTS wizard to associate
this document type column with your table so SQL FTS will know that there is
html content in this row...."

Thanks,

Jake

>
> "GitarJake" <gitarjake@spammersuntied.com> wrote in message
> news:6II5c.6930$rQ.3711@lakeread04...
> > Ok,
> >
> > Thanks Hilary. I can't make this change right away. But I have found
> the
> > msdn article that explains it.
> >
> > I have another question for you.
> >
> > Is MS Search installed by Sql install? I'm having problems enabling
FTI
> on
> > a desktop running Sql 7 Desktop. Neither FTI nor MS Search are choices
> > during the install. And MS Search is not already installed.
> >
> > What to do to get FTI up?
> >
> > TIA,
> >
> > Jake
> >
> > "Hilary Cotter" <hilaryk@att.net> wrote in message
> > news:%235%23Fai3CEHA.2256@TK2MSFTNGP12.phx.gbl...
> > > to have your html content indexed withough the html formatting tags,
you
> > > need to store your documents in an image data type column. then you
have
> > to
> > > add a char or varchar(4) column to your table, and update this column
to
> > > have a value of .htm
> > >
> > > Then you need to use the SQL FTS wizard to associate this document
type
> > > column with your table so SQL FTS will know that there is html content
> in
> > > this row.
> > >
> > > HTH
> > >
> > > "John Martin" <john.martin@spammersuntied.com> wrote in message
> > > news:d6F5c.6825$rQ.1761@lakeread04...
> > > > Hi Hilary,
> > > >
> > > >
> > > > "Hilary Cotter" <hilaryk@att.net> wrote in message
> > > > news:%23uAS8h2CEHA.2308@tk2msftngp13.phx.gbl...
> > > > > did you use the document column type? ie
> > > > >
> > > > > sp_fulltext_column 'TableName','ColumnName',
> > > > > 'Add',1033 'DocumentTypeColumn'
> > > > >
> > > > > where documenttypecolumn is a char or varchar(4) column containing
> > .htm?
> > > >
> > > > Hilary, I apologize. I am very green re: sql server. Could you
> > explain
> > > > this further?
> > > >
> > > > > and you are storing your html doc in an image column?
> > > >
> > > > The data-type of the column is ntext. Also, this is Sql Server
2000
> on
> > > > Windows 2000 and XP Pro
> > > >
> > > >
> > > >
> > > > Thanks,
> > > >
> > > > Jake
> > > >
> > > >
> > > >
> > > > >
> > > > > "GitarJake" <wiekiewatchee@spamkiller.net> wrote in message
> > > > > news:YkD5c.3242$F91.3132@lakeread05...
> > > > > > Hi all,
> > > > > >
> > > > > > How do I get a table that has been Full Text Indexed, whose data
> has
> > > > been
> > > > > > input through an HTML editor to be searched by SQL without
> searching
> > > the
> > > > > > HTML tags and code.
> > > > > >
> > > > > > I have a bunch of pages on my site; the content of which is
stored
> > in
> > > a
> > > > > Sql
> > > > > > Database. When I search for the word "Font", I get everything!
> > How
> > > > do
> > > > > I
> > > > > > keep that from happening?
> > > > > >
> > > > > > BTW, I'm kinda new here. Can you tell?
> > > > > >
> > > > > > TIA,
> > > > > >
> > > > > > Jake
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: FTI, Searching and other Filters
    ... SQL 2005 doesn't allow you to create a index on a view if the view contains ... Remove the FTI from the table. ... Add an OfficeID column to the table and populate it. ... But what they would really like is the top 1500 rank for documents ...
    (microsoft.public.sqlserver.fulltext)
  • Re: FTI, Searching and other Filters
    ... VARBINARYinstead of TEXT or IMAGE (which are deprecated in sql 2005). ... We can't add any special tokens, the content is an image field. ... "SQL SERVER DBA"') ... Remove the FTI from the table. ...
    (microsoft.public.sqlserver.fulltext)
  • How does LIKE actually work??
    ... I have a list of internet URLs in an SQL table. ... This command, instead of matching everything that starts with 'MyURL', simply returns the entire contents of the table - all 10,500 rows! ... I've never used FTI - wouldn't know where to begin with that! ...
    (microsoft.public.sqlserver.fulltext)
  • Re: how do I change the user install wizard to create user folder in different location?
    ... Some people read the instructions in such a way that they install both a new ... instance of sql, ... Never slight the SBS wizards. ... I reinstalled from scratch using the Dell OpenManage Server ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS 2003 and Sql Server ~ Client Install
    ... I've found the client tools and have now ... A word mail merge document could access a SQL database via ... We want to install to gain an understanding. ... Once we've managed to install the SQL Server Client we can start to ...
    (microsoft.public.backoffice.smallbiz2000)