FullText Search giving Case sensitive results , Big Problem!!

[Saurabh Arora]

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