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 2007

Tip: Looking for answers? Try searching our database.

Freetexttable Not Finding Inflectional Forms

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Krip - 22 Feb 2007 16:48 GMT
We're using SQL Server 2005 service pack 1.  It was my understanding that
FreeTextTable automatically includes inflectional forms.  We're not able to
get any inflectional forms of words during the search (even if we use
Contains with the special syntax).  Are we missing something in the server
configuration?  Or is there a bug somewhere?

Thanks,
Krip
Hilary Cotter - 23 Feb 2007 00:07 GMT
Are  you wrapping your freetext search in double quotes - this disables the
stemming (inflectional search)?

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

> We're using SQL Server 2005 service pack 1.  It was my understanding that
> FreeTextTable automatically includes inflectional forms.  We're not able
[quoted text clipped - 4 lines]
> Thanks,
> Krip
Krip - 23 Feb 2007 13:36 GMT
Hilary,

Nope, not wrapping with double quotes.  Here's the clause:

   INNER JOIN FreeTextTable(myTable, myField, 'tests') as FTT

I have 'test' in the data but 'tests' doesn't find it.  That's just one
example (fox works but not foxes; landed works but not landing).

The following doesn't work either:

   SELECT *
   FROM myTable
   WHERE CONTAINS(*, 'FORMSOF (INFLECTIONAL, foxes)')

Also, I've now installed SP2 and rebuilt the catalag - same issue.

Is there some place to enable inflectional forms?  Or is there a dictionary
to populate?

Thanks,
Krip
Hilary Cotter - 23 Feb 2007 18:19 GMT
Perhaps it is a language issue, what does this return? sp_configure 'default
full-text language'

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

> Hilary,
>
[quoted text clipped - 18 lines]
> Thanks,
> Krip
Krip - 23 Feb 2007 19:00 GMT
Hilary,

It returns the following:

   name: default full-text language
   minimum: 0
   maximum: 2147483647
   config_value: 1033
   run_value: 1033

Thanks for your help,
Krip
 
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.