|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Access Text Within A SQL Binary FieldIs there any way to access the text within a SQL Binary object? For example
if I wanted to count the number of words within a Word document that had been added to a binary field in the database. I figure the IFilters used by the Full-Text indexing service must do something like this in order to create it's keyword index database. Look for: textptr, readtext, writetext, updatetext, textvalid and
sp_invalidate_textptr in the BOL. Show quote "Anthony" <Anth***@discussions.microsoft.com> wrote in message news:3CFF2482-3A52-40E1-B629-3873ACAEDC41@microsoft.com... > Is there any way to access the text within a SQL Binary object? For > example > if I wanted to count the number of words within a Word document that had > been > added to a binary field in the database. > > I figure the IFilters used by the Full-Text indexing service must do > something like this in order to create it's keyword index database. Anthony,
Out-of-the box with either SQL Server 2000 or SQL Server 2005 (Yukon) this is not possible. You would need to either parse the text of the MS Word documents before you inserted the documents into an IMAGE datatype or write your own IFilter *wrapper* to capture the text into a separate text based column. The MSDN Platform SDK has code examples and utilities that can be used to the later, if you want to do this. Yes, you are correct, that is what the IFilters (Microsoft's and 3rd party) do. Regards, John Show quote "Anthony" <Anth***@discussions.microsoft.com> wrote in message news:3CFF2482-3A52-40E1-B629-3873ACAEDC41@microsoft.com... > Is there any way to access the text within a SQL Binary object? For > example > if I wanted to count the number of words within a Word document that had > been > added to a binary field in the database. > > I figure the IFilters used by the Full-Text indexing service must do > something like this in order to create it's keyword index database.  |
|||||||||||||||||||||||
Other interesting topics