Hi all,
I've just made my first search engine that search trough an MySQL database on a corporate portal. Everyting works fine except for one thing. When I retrieve a database record based on a search word, I use the REPLACE function to make the search word in the recordset
Highlighted. I used the source from WWF as an example.
The problem is that when I use upercase words as a search words, the lowercase words in the dataset are replaced by upercase words. e.g. "HeLo WoRlD" as the search criteria will replace "Hello world" in my search results by "HeLo WoRlD".
The same problem occurs in the search function of WWF 7.9. (I've noticed that this problem is solved in WWF 8.0 A) Does anyone knows how I can solve this for my Search engine? (i've search the forum but didn't find a workarround)
Thanks in advance.
--
Alexander
Edited by webbasterd - 16 February 2005 at 5:04pm