accent-insensitive full text searching for modern spanish

accent-insensitive full text searching for modern spanish

Post by QWxiYXRyb3 » Tue, 25 Sep 2007 22:44:03


Hi

I believe that SQL 2000 full text is accent sensitive by default for full
text indexing. Can anyone confirm this?

Also. is there any work-around?

What I want to do is seach for "cancer" and return everything that has
"cancer" and "cncer".

Thanks for any pointers.
 
 
 

accent-insensitive full text searching for modern spanish

Post by Hilary Cot » Fri, 28 Sep 2007 11:17:06

Yes, it is. SQL 2005 has the option to be accent sensitive or insensitive.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

Looking for a SQL Server replication book?
http://www.yqcomputer.com/

Looking for a FAQ on Indexing Services/SQL FTS
http://www.yqcomputer.com/
"Albatross Singh" < XXXX@XXXXX.COM > wrote in