Groups | Blog | Home
all groups > sql server full text search > march 2005 >

sql server full text search : Can you do accent insensitive full text searches?



Neil
3/29/2005 10:45:04 AM
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 ?
Neil
3/29/2005 11:35:02 AM
Will SQL 2000 work with the SPS binary?

[quoted text, click to view]
Hilary Cotter
3/29/2005 2:01:17 PM
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.

--
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

[quoted text, click to view]

Hilary Cotter
3/29/2005 3:03:49 PM
No, they are insulated from each other. It was different in SPS 01. STS
(Sharepoint Team Services) can use SQL FTS.

--
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

[quoted text, click to view]

AddThis Social Bookmark Button