Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 FULLTEXT with accent insensitivity and SQLServer 2K

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-08-24 : 13:07:59
Thierry writes "Hello,

object:
I would like to search on words having accent like "bébé" but my query is on the same word without accent in other words "bebe"
It's the same word in fact in french both mean "baby".
So when i enter bebe i would like to find records having words with the syntax 'bebe' or 'bébé' or 'bébe', etc...
this is exactly what sqlserver does when we search using sql index. Now I want to use the fulltext component of sqlserver 2K to do it.
By the way sharepoint which also use mssearch to do fulltext search works fine on this case.
could you tell me why sqlserver react a different way which in fact is not good at all.
If this is not a bug then tell me how to set it up.

thanks a lot for any help of your part.

"
   

- Advertisement -