MySQL Forums
Forum List  »  MyISAM

Re: FullText Search giving Case sensitive results , Big Problem!!
Posted by: Rick James
Date: December 09, 2011 12:31PM

Terminology...
latin1 is a "character set"
latin1_bin is a "collation" within the latin1 character set.

I would expect case INsensitive searches if you do nothing special. That is nothing you are obviously doing wrong; let's spell out some specifics, looking from something overlooked...
SHOW CREATE TABLE
SELECT an example row (by PRIMARY KEY, not by FULLTEXT) that is not being found correctly.
SELECT ... WHERE MATCH ... -- set up so that it _should_ get that same example row.
Do that last SELECT first with the matching case, then with a different case. (You are saying is that one will find the row, the other will not?)

Options: ReplyQuote




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.