Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Hit Highlighting/Snippeting

  
   Database Help (Home) -> Full Text RSS
Next:  Convert RecordSet to comma separated values  
Author Message
superware

External


Since: Oct 13, 2008
Posts: 2



(Msg. 1) Posted: Mon Oct 13, 2008 4:24 am
Post subject: Hit Highlighting/Snippeting
Archived from groups: microsoft>public>sqlserver>fulltext (more info?)
Hello,

I'm trying to use SQL Server 2008 Express to index large quantities of
documents, it seems to work very well.

My problem started when I tried to use the same word-breaker used by
SQL Server in order to highlight the search terms from C#. With SQL
Server 2005 I simply used the same word-breaker found in the Binn
folder, which implemented IWordBreaker, but with 2008 it seems to use
NaturalLanguage6.dll (and NlsData*.dll, NlsLexicons*.dll) but this one
doesn't implement any interface that I know. So... can someone please
help me? how can I word-break from C#?

Thanks,
Superware

 >> Stay informed about: Hit Highlighting/Snippeting 
Back to top
Login to vote
Michael Coles

External


Since: Oct 15, 2008
Posts: 4



(Msg. 2) Posted: Wed Oct 15, 2008 2:45 pm
Post subject: Re: Hit Highlighting/Snippeting [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
All word breakers implement the IWordBreaker interface:
http://msdn.microsoft.com/en-us/library/ms691079(VS.85).aspx. I don't know
if there are any .NET wrappers available for these, they're COM components,
so you may have to create your own COM interop wrappers.

"superware" wrote in message

> Hello,
>
> I'm trying to use SQL Server 2008 Express to index large quantities of
> documents, it seems to work very well.
>
> My problem started when I tried to use the same word-breaker used by
> SQL Server in order to highlight the search terms from C#. With SQL
> Server 2005 I simply used the same word-breaker found in the Binn
> folder, which implemented IWordBreaker, but with 2008 it seems to use
> NaturalLanguage6.dll (and NlsData*.dll, NlsLexicons*.dll) but this one
> doesn't implement any interface that I know. So... can someone please
> help me? how can I word-break from C#?
>
> Thanks,
> Superware

 >> Stay informed about: Hit Highlighting/Snippeting 
Back to top
Login to vote
superware

External


Since: Oct 13, 2008
Posts: 2



(Msg. 3) Posted: Mon Oct 20, 2008 3:22 pm
Post subject: Re: Hit Highlighting/Snippeting [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Are you sure about this? I know word-breakers supplied by/for SQL
Server 2005 implemented IWordBreaker. It seems NaturalLanguage6.dll
doesn't but rather implement ILexicon, ITextContext ITextChunk, ect...
any ideas?

On Oct 15, 8:45 pm, "Michael Coles" <michaelcoAToptonlineDOTnet>
wrote:
> All word breakers implement the IWordBreaker interface:http://msdn.microsoft.com/en-us/library/ms691079(VS.85).aspx.  I don't know
> if there are any .NET wrappers available for these, they're COM components,
> so you may have to create your own COM interop wrappers.
 >> Stay informed about: Hit Highlighting/Snippeting 
Back to top
Login to vote
Michael Coles

External


Since: May 29, 2008
Posts: 55



(Msg. 4) Posted: Mon Nov 24, 2008 11:26 pm
Post subject: Re: Hit Highlighting/Snippeting [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
I'm not familiar with the ILexicon, ... interfaces. I have written word
breakers for SQL Server 2008 using the documented IWordBreaker. I also have
heard that some folks have written .NET word breakers, though I haven't
written any in .NET myself. You should be able to create wrappers around
IWordBreaker without too much trouble, but I think the main issue would be
performance...

--

========
Michael Coles
"Pro T-SQL 2008 Programmer's Guide"
http://www.amazon.com/T-SQL-2008-Programmer-rsquo-Guide/dp/143021001X


"superware" wrote in message

Are you sure about this? I know word-breakers supplied by/for SQL
Server 2005 implemented IWordBreaker. It seems NaturalLanguage6.dll
doesn't but rather implement ILexicon, ITextContext ITextChunk, ect...
any ideas?

On Oct 15, 8:45 pm, "Michael Coles" <michaelcoAToptonlineDOTnet>
wrote:
> All word breakers implement the IWordBreaker
> interface:http://msdn.microsoft.com/en-us/library/ms691079(VS.85).aspx. I
> don't know
> if there are any .NET wrappers available for these, they're COM
> components,
> so you may have to create your own COM interop wrappers.
 >> Stay informed about: Hit Highlighting/Snippeting 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
funny search results with 'contains' clause - hi, it is really funny how ft search works: it seems to depend highly on what could be indexed, but it still doesn't follow a determined order. consider the following queries: select name from person where contains(name, 'hammer') select name from..

Insert Into Without Log - Hi, Can I create an Insert Into Query without sql server registration log? Thx.

SQL 2K : custom word breaker ? - Hi, Is it possible to create a custom word breaker for SQLServer fulltext.... I use french word breaker, but for some specific tables, it's not exactly what I want... Seems such a dream will be feasible in SQL 2K5. Please anyone who knows, tell me the....

restore to another server of db with FT catalogs - If we restore a backup copy of a production db having FT catalogs onto a laptop running SQL Server Developer version, the restored db will contain references to FT catalogs whose underlying system files are not yet present on the laptop (because backup..

fulltext search not working - HI!, Fulltext search is not working, i have two databases, fulltext search functionality was working fine on both of them till now. but suddenly fulltext search on one of the databases started giving out errors. when i try to populate, rebuild was..
   Database Help (Home) -> Full Text All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]