Accent-sensitive

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
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.html
|||I Think you want to say the SQL FTS is not Accent Insensitive. If it was Accent Insensitive, Marco would have no problem !
|||Are you sure, Hilary, there is no way to change the SQL server'catalog sensitivity ?
|||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.
"Syl20" <anonymous@.discussions.microsoft.com> wrote in message
news:88DDAA02-A424-4FE4-9E3A-F797ED2D543B@.microsoft.com...
> I Think you want to say the SQL FTS is not Accent Insensitive. If it was
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.
"Syl20" <anonymous@.discussions.microsoft.com> wrote in message
news:F2EEC4B5-67E6-4AFB-B2D9-700490242FC5@.microsoft.com...
> Are you sure, Hilary, there is no way to change the SQL server'catalog
sensitivity ?
|||Yes, you are right.
This possibility will be available with Microsoft SQL-Server 2005 ("Yukon")
|||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
"Syl20" <anonymous@.discussions.microsoft.com> wrote in message
news:A9DEF7CE-13B2-49E7-86ED-2A9B759B13D3@.microsoft.com...
> Yes, you are right.
> This possibility will be available with Microsoft SQL-Server 2005
("Yukon")