SQL Server Full Text Search Special character issue

Posted by ManojTrek on Stack Overflow See other posts from Stack Overflow or by ManojTrek
Published on 2010-05-12T15:17:49Z Indexed on 2010/05/12 15:54 UTC
Read the original article Hit count: 411

Filed under:

full

|

full-text-search

Hello,

I have Full Text catalog created in SQL Server 2005, when I search the text like "Bolivia's History", it returns all the result matching to that, but if I use "Bolivias History", it does not return anything, I am very new to Full Text Search stuff, any lead how to ignore the special character ("'"), in Full Text Search?

Thanks in Advance, Manoj

© Stack Overflow or respective owner

Related posts about full

Lucene.NET vs SQL Server Full-text – Generating a million records and a full-text index

as seen on Dot net Slackers - Search for 'Dot net Slackers'
In this article we will take a look at how SQL Server performs with one million records in a table. We will create a quick data pumper program to fill up a table with a million dynamically created rows of data. From there we will take a look at querying the data without any special optimizations… >>> More
Problems with NVIDIA drivers: White screen with full(or almost full)screen apps

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
My NVIDIA graphic card is a 7050/610i. My problem is that after upgrading to the last NVIDIA drivers when I use fullscreen apps (or almost fullscreen) the windows goes white. My xorg.conf file: # nvidia-xconfig: X configuration file generated by nvidia-xconfig # nvidia-xconfig: version 270.29 … >>> More
df shows partition as full, but du shows it as only 25% full

as seen on Server Fault - Search for 'Server Fault'
I have a humble linux server to do some stuff for me. I only have an old 16gig drive in it. df -h Filesystem Size Used Avail Use% Mounted on /dev/md1 16G 16G 0 100% / /dev/md0 121M 14M 101M 13% /boot tmpfs 502M 0 502M 0% /dev/shm but… >>> More
Printing using full page (bypassing hardmargins/printing full bleed/borderless)

as seen on Stack Overflow - Search for 'Stack Overflow'
Is it possible to override printer hardmargins and use all of the page when printing a document programmatically with .NET? >>> More
Full-text search error during full-text index population : Error Code '0x80092003'

as seen on Stack Overflow - Search for 'Stack Overflow'
Dear All, I have problem with Full-Text Search service in production environment. Each time I rebuild full-text catalog, there is no error in User Interface, but there is no data in Full-Text Catalog Item Count : 0 Catalog size : 0 MB OS : Windows Server 2003 R2 Standard Edition Service Pack2 SQL… >>> More

Related posts about full-text-search

Error while configuring Sql server 2005 for full text search

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to index a table for full text search on a SQL server 2005. When I select the change tracking as Automatic and click on the next button, I get the following error TITLE: Microsoft SQL Server This wizard will close because it encountered the following error: For help,… >>> More
Configuring Sql server 2005 for full text search

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to index a table for full text search on a SQL server 2005. When I select the change tracking as Automatic and click on the next button, I get the following error TITLE: Microsoft SQL Server This wizard will close because it encountered the following error: For help,… >>> More
How to customize the full text search ?

as seen on Stack Overflow - Search for 'Stack Overflow'
Full text search is becoming a tedious job using the relational databases’ approach. Can anybody suggest an alternate option if any or way to customize the full text search ? >>> More
WHoosh (full text search) index problem

as seen on Stack Overflow - Search for 'Stack Overflow'
iam having the following problem with whoosh full text search engine. 1.After syncdb i am creating the intial index from the database objects. 2.it is working fine.I can able to search the data and see the results. 3.after that in one of my view i have added another document (via signals) to the… >>> More
How to implement full text search in Django?

as seen on Stack Overflow - Search for 'Stack Overflow'
I would like to implement a search function in a django blogging application. The status quo is that I have a list of strings supplied by the user and the queryset is narrowed down by each string to include only those objects that match the string. See: if request.method == "POST": form… >>> More