MySQL Forums
Forum List  »  MyISAM

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

Hi

This is the structure of my table : -

CREATE TABLE `table` (
`Col1` int(10) NOT NULL auto_increment,
`Col2` varchar(50) NOT NULL,
`Col3` varchar(35) default NULL
KEY `Col2` (`isbn13`),
KEY `Col3` (`isbn10`),
FULLTEXT KEY `name`(`Col2`,`Col3`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1


I am having an unusual problem, I had this same structure and composition and was getting fulltext case insensitive results till few days ago when i realised i am getting case senstive results, I had to drop all tables and databases and reload them using dump.

after reloading, i found out that in 4 databases the results of fulltext are case sensitive where as in other 3 databases the results are case in sensitive.

I want all the fulltext results to be case insensitive, which i had before but now its gone, so please SMS...Save My Soul :)


P.S - the reason to reload all the databases was I had different character sets for different databases and i thought that was the reason for case sensitive searches.


Please guide.

Thanks

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.