Very Computer

Hello,
I know this is not strictly a FTS question. I have a number of htm-files
stored in a column of the Text data type. Is it possible to convert this
data to the Binary data type in order to use the FTS-filters on SQL Server
2000?. If yes what would be the most rational way to go about this. SQL
server does not allow this conversion directly.
thanks

Niels Hansen

regretably there is no way to do this through EM, SQL DMO,
TSQL, etc AFAIK.

I would suggest some vbscript to connect to your table,
export it out in a row by row fashion the then push it
back into your table in a char/varchar col.

Quote:>-----Original Message-----
>Hello,
>I know this is not strictly a FTS question. I have a
number of htm-files
>stored in a column of the Text data type. Is it possible
to convert this
>data to the Binary data type in order to use the FTS-

filters on SQL Server

Quote:>2000?. If yes what would be the most rational way to go
about this. SQL
>server does not allow this conversion directly.
>thanks

>Niels Hansen

>.

Hilary,
Well, yea, but you forgot about DTS or BCP in/out...
Basicly, to use the new SQL 2000 "Image Filter (IFilter for HTML)" you need
to convert the TEXT column datatype to an IMAGE datatype. This is not easily
done and requires, exporting the data via DTS or BCP out to a file of the
TEXT column, then alterting the table to drop the TEXT column and add an
IMAGE and doc extension column and then import DTS or BCP in the html data
to the IMAGE column. Note, this could all be done in one DTS package.

Once done, you can use the HTML IFilter with the doc extenstion column
(value of: htm or html) and create a FT Index via the FT Wizard and using
the correct word breaker and extension column. When complete, your FTS
quieres will search on the html data and not the html metatags...
Regards,
John

Quote:> regretably there is no way to do this through EM, SQL DMO,
> TSQL, etc AFAIK.

> I would suggest some vbscript to connect to your table,
> export it out in a row by row fashion the then push it
> back into your table in a char/varchar col.

> >-----Original Message-----
> >Hello,
> >I know this is not strictly a FTS question. I have a
> number of htm-files
> >stored in a column of the Text data type. Is it possible
> to convert this
> >data to the Binary data type in order to use the FTS-
> filters on SQL Server
> >2000?. If yes what would be the most rational way to go
> about this. SQL
> >server does not allow this conversion directly.
> >thanks

> >Niels Hansen

> >.