 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Other Technologies / Full-Text Search / June 2006accent sensitive *and* insensitive
Forgive me if this has already been asked, but I need to be able to search either with accent sensitivity *or* insensitivity, depending on user settings or locale. Is there any way to set up my indexing (either in 2000 or 2005) so that I can choose during the search itself whether or not to be sensitive to accents? With regular queries, I can use different collations to achieve this, but I'm not sure about full text. Thanks, Lisa You can't do this in SQL 2000 easily. the only way to do it is through thesaurus expansions using FreeText. In SQL 2005 you can create your catalogs as accent sensitive or insensitive. Place the table in the accent sensitive catalog and an full text indexed view of the same table in the accent insensitive catalog.  SignatureHilary 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 > Forgive me if this has already been asked, but I need to be able to > search either with accent sensitivity *or* insensitivity, depending on [quoted text clipped - 7 lines] > Thanks, > Lisa > You can't do this in SQL 2000 easily. the only way to do it is through > thesaurus expansions using FreeText. In SQL 2005 you can create your > catalogs as accent sensitive or insensitive. Place the table in the accent > sensitive catalog and an full text indexed view of the same table in the > accent insensitive catalog. Thanks, Hilary. But I thought the thesaurus expansion with FORMSOF was only available starting with 2005. Isn't 2000 limited to inflective expansions? If I'm misunderstanding, could you please point me somewhere that shows how you'd do thesaurus expansions in 2000? Thanks again, Lisa Formsof is not available in SQL 2000, but the thesaurus feature works in SQL 2000 FreeText. SignatureHilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. 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 >> You can't do this in SQL 2000 easily. the only way to do it is through >> thesaurus expansions using FreeText. In SQL 2005 you can create your [quoted text clipped - 10 lines] > Thanks again, > Lisa > Formsof is not available in SQL 2000, but the thesaurus feature works in SQL > 2000 FreeText. I hear what you're saying, but when I look in the Online Books help file for SQL 2000, the FREETEXT predicate says nothing at all about thesaurus features. In fact, the word "thesaurus" doesn't appear anywhere in that help file. Do you have any information you could provide about this feature, or could you point to a place where such information might be obtained? Thanks, Lisa http://www.indexserverfaq.com/thesaurus.htm SignatureHilary Cotter Director of Text Mining and Database Strategy RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. This posting is my own and doesn't necessarily represent RelevantNoise's positions, strategies or opinions. 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 >> Formsof is not available in SQL 2000, but the thesaurus feature works in >> SQL [quoted text clipped - 10 lines] > Thanks, > Lisa |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.