Re: Apostrophes in Full Text Search
- From: "Hilary Cotter" <hilary.cotter@xxxxxxxxx>
- Date: Mon, 10 Sep 2007 11:01:32 -0400
All the interfaces I am aware of (except Query Analyzer) will double quote
them.
However you can also put a replace(@myString,char(39), char(39)+char(39) in
your tsql code before it hits the full-text index.
--
RelevantNoise.com - dedicated to mining blogs for business intelligence.
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
"Ramesh" <nospam@xxxxxxxxxxxxxxxxxx> wrote in message
news:8bc58682-6af9-4ee2-b297-f692eb95b85b@xxxxxxxxxxxxxxxxxxxxx
I would like to search the words like O'Donnel, O'Connor,Steve's etc.. in
the attachments. Tried to use ContainsTable and replaced the apostrophe
with another before sending to the search engine.
Also i have to search Connor in O'connor
Any thoughts?
From
http://www.developmentnow.com/g/104_2007_6_0_0_0/sql-server-fulltext.htm
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com
.
- References:
- Apostrophes in Full Text Search
- From: Ramesh
- Apostrophes in Full Text Search
- Prev by Date: Re: Capacity planning and performance tuning - SQL 2005 Full text inde
- Next by Date: Re: Full-text search content
- Previous by thread: Apostrophes in Full Text Search
- Next by thread: Space Required to store a file in database
- Index(es):
Relevant Pages
|
