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 / March 2005

Tip: Looking for answers? Try searching our database.

Can you do accent insensitive full text searches?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Neil - 29 Mar 2005 19:45 GMT
Some people are saying that  the only way to do a accent insensitive full
text search under SQL 200 is to replace mssearch with the version that comes
with Share Point Server.  Is this true or is ther another way?  If it is true
how are you supposed to send this to clients as not everyone has SPS ?
Can you download a newer version to install with SQL?
Reply to this Message
Hilary Cotter - 29 Mar 2005 20:01 GMT
No, because SPS 2003 uses a different version of MSSearch. So if you install
SQL FTS and SPS on the same machine there will be two binaries called
MSSearch that are not shared between both products.

SQL FTS 2005 is accent insensitive when you create the catalog from the GUI
and accent sensitive when you create it from the Create FullText Catalog
command.

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

> Some people are saying that  the only way to do a accent insensitive full
> text search under SQL 200 is to replace mssearch with the version that comes
> with Share Point Server.  Is this true or is ther another way?  If it is true
> how are you supposed to send this to clients as not everyone has SPS ?
> Can you download a newer version to install with SQL?
Reply to this Message
Neil - 29 Mar 2005 20:35 GMT
Will SQL 2000 work with the SPS binary?

> No, because SPS 2003 uses a different version of MSSearch. So if you install
> SQL FTS and SPS on the same machine there will be two binaries called
[quoted text clipped - 11 lines]
> > how are you supposed to send this to clients as not everyone has SPS ?
> > Can you download a newer version to install with SQL?
Reply to this Message
Hilary Cotter - 29 Mar 2005 21:03 GMT
No, they are insulated from each other. It was different in SPS 01. STS
(Sharepoint Team Services) can use SQL FTS.

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

> Will SQL 2000 work with the SPS binary?
>
[quoted text clipped - 13 lines]
> > > how are you supposed to send this to clients as not everyone has SPS ?
> > > Can you download a newer version to install with SQL?
Reply to this Message
 
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.