Re: SQL Server Html Search Question

From: Hilary Cotter (hilaryk_at_att.net)
Date: 03/18/04 

Date: Thu, 18 Mar 2004 11:00:15 -0500

Is this version installed on Win9x or WinMe machine? I can't recall is
desktop is the equivalent of the Developer edition or MSDE.

You can index and search Japanese and Chinese html content in the image
column, but you must have one column for Japanese and one for Chinese.

Also you must install the Japanese and Chinese language resources on your
machine.

"GitarJake" <wiekiewatchee@spamkiller.net> wrote in message
news:bM_5c.4214$F91.3693@lakeread05...
>
> "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