MySQL Forums
Forum List  »  MyISAM

Re: FullText Search giving Case sensitive results , Big Problem!!
Posted by: Saurabh Arora
Date: December 08, 2011 06:35AM

OK.. but i want the search to be performed in CASE INSENSITIVE manner, which is not the case right now and the charactes set is latin1 and NOT laint1_bin.

Y the results are case sensitive? what can i do to make it case Insensitive.


P.S. - when I do->

Show table status;

The table collation is "latin1_swedish_ci"

in all the tables on which I am using fulltext (bollean)

Edited 1 time(s). Last edit at 12/08/2011 06:44AM by Saurabh Arora.

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.