On Apr 4, 2009, at 4:17 PM, Michael Southwell <[email protected]
> wrote:
I have a table with a keyword field and a fulltext index on that
field.
snip
Searches are supposed to be case-insensitive so WHERE
MATCH (keyword) AGAINST ('spaniel') should work but in fact
returns zero rows
What's the charset and collation for the field? Maybe it's binary.
_______________________________________________
New York PHP Community MySQL SIG
http://lists.nyphp.org/mailman/listinfo/mysql
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
