Unusual characters in search

From: Iain Shanks <shanksi_at_logica.com>
Date: Wed, 08 Dec 1999 15:48:41 +0000
Message-ID: <384E7DD9.859344D1@logica.com>

Can anyone help?

We are passing a search string from a web page to a search engine that is searching through 500,000+ records on an indexed column using:

where <field_name> like '%<search_string>%'

this is causing problems when we pass through search strrings containing characters:

' Apostophe
% Percent (wildcard)
" Speech mark
; Semi-colon
_ Underscore (single char wildcard)

For efficiency we've decided to strip out these characters using some client side script and then pass the resulting search string for the select statement. I can't find a definitive list of characters that cause the above like statement to screw up. Can anyone help?

I don't want to use the escape keyword as this will slow the search down! Received on Wed Dec 08 1999 - 09:48:41 CST