sql server full text search: Unfortunately SQL FTS is not Accent Sensitive, ie a search on a word like cafe will not match with a search on a word like cafe (with an accent)

You have to trap for words which could be accented in your search phrase and then expand them into a search on the accented and unaccented versions of this work

Looking for a SQL Server replication book
http://www.nwsu.com/0974973602.htm

My SQL is instaled with CAse-Insensitive and Accent-Insensitive, but when I
search some thing with Full Text Search the result is diferent using accent
or not.

My server is a Windows 2000 server and MS SQL Server 2000.

Tia

Marcos Stabel

Accent sensitive means that when I query on cafe, in a table like this

select * from TableName where col1='cafe' I will not get rows returned to
the accented version of cafe.

Accent insensitive means that I will.

With SQL FTS, the tokens found in your columns you are full text indexing
are stored as unicode, so a cafe is a different unicode sequence than the
accented version of cafe.

You can select how SQL Server treats accents, but not MSSearch, which is the
engine which does your searching in SQLFTS.

So to be totally correct - SQL FTS is accent sensitive or not accent
insensitive. Thanks for the correction.



[quoted text, click to view]
Accent Insensitive, Marco would have no problem !

There is no way to change the accent handling capabilities of SQL Server
FTS, other than expanding your search phrase to search on the accented and
unaccented versions of the phrase.

[quoted text, click to view]
sensitivity ?

Yes, you are right

Syl20,
Yes, this feature will be in Microsoft SQL-Server 2005 ("Yukon"), for
example:

USE Adventureworks
GO
CREATE FULLTEXT CATALOG Employee_FTC WITH ACCENT_SENSITIVITY = ON
CREATE FULLTEXT INDEX ON Employee(FirstName, LastName, Title, EmailAddress)
KEY INDEX PK_Employee_EmployeeID ON Employee_FTC

Regards,
John




[quoted text, click to view]
("Yukon")