MySQL Forums
Forum List  »  Full-Text Search

MATCH returning case sensitive results
Posted by: Nathan Ladd
Date: February 26, 2008 01:29PM

Everything I read says the MATCH AGAINST function searches will not be case sensitive, but whenever I use these functions I am returned case sensitive results. For testing purposes I created the table and query exactly as described at http://dev.mysql.com/doc/refman/5.0/en/fulltext-natural-language.html but rather than having my query return two rows matching both 'database' and 'DataBase' as shown in the example. I am only returned one row matching 'database'. I am using MySQL version 4.1.20-max-log on a linux server. Does anyone know why my query results are case sensitive?

Thanks
Nathan

Options: ReplyQuote


Subject
Views
Written By
Posted
MATCH returning case sensitive results
10103
February 26, 2008 01:29PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.