MySQL Forums
Forum List  »  Full-Text Search

Advanced Search
New Topic

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

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
MATCH returning case sensitive results
10163
Nathan Ladd
February 26, 2008 01:29PM
Re: MATCH returning case sensitive results
3914
Marco Patania
August 29, 2008 04:13AM


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.