Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Full-Text Search / February 2005

Tip: Looking for answers? Try searching our database.

SQL 2K : custom word breaker ?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sylvain - SdV Plurim?dia - 22 Feb 2005 08:41 GMT
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 truth! :)

Thanks,

Sylvain H,
DBA.
Hilary Cotter - 22 Feb 2005 11:59 GMT
Yes it is. Consult this article for more info.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/indexsrv/html/i
xrefint_93xu.asp


Perhaps if you could tell us exactly what you are trying to accomplish, we
could suggest other techniques.

Signature

Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

>  Hi,
>
[quoted text clipped - 9 lines]
> Sylvain H,
> DBA.
Sylvain - SdV Plurim?dia - 22 Feb 2005 14:26 GMT
Thanks for your answer.

Ok, so here is my problem : for french WB, searching for the "red" word in
"red/white" is ok. But, if there is a space after the '/' char (like in
"red/ white"), it won't match..... There are tons of such example so that
frankly, this is a sort of bug for me, but it's not the subject here :)
I could use neutral WB, but then there are a lot other complications and
this is not an option.

Currently, I have to use a program of mine that :
1) export a column from a table into a file
2) for that file do some transformations (cut accents etc...)
3) import this "new" column in table dedicated to full-text
I don't really wan't to spend my time with that anymore; I have to replicate
data because of some strange WB behaviour.

So my real problem is that our developpers are going crazy if there is not a
simple rule for word breaking.
My idea is then to build my own WB, so that I can decide __exactly__ when to
break or not.
By the way, is there "somewhere" the real specification/algorithm for the
different languages WB ??

From your answer, I understand I have to implement IWordBreaker interface.
Problem is I 've had built only one COM IFilter in the past, and from what I
remember, it did not work very well :)
So, I'm not familiar with COM programming but I understand it is the way to
go.

Is there any other simple sample someone can share please ? MS samples are
good, but do not focus enough on what is important IMO.

Thanks again,

Sylvain,
DBA.

> Yes it is. Consult this article for more info.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/indexsrv/html/i
xrefint_93xu.asp


> Perhaps if you could tell us exactly what you are trying to accomplish, we
> could suggest other techniques.
[quoted text clipped - 14 lines]
> > Sylvain H,
> > DBA.
Hilary Cotter - 22 Feb 2005 15:16 GMT
Unfortunately I think your best bet is to look for a good COM developer -
you could try gt.com.au. They did some iFilter work for me and they are very
good.

Signature

Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> Thanks for your answer.
>
[quoted text clipped - 34 lines]
>
> > Yes it is. Consult this article for more info.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/indexsrv/html/i
xrefint_93xu.asp


> > Perhaps if you could tell us exactly what you are trying to accomplish, we
> > could suggest other techniques.
[quoted text clipped - 15 lines]
> > > Sylvain H,
> > > DBA.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.