Re: Full-Text Search not work in new version!

[mahmud mofrad]

Thanks for answer.
Not work = No results!
new version = mysql 5.5

CREATE TABLE IF NOT EXISTS `products` (
`id` int(10) unsigned NOT NULL auto_increment,
`company_id` int(10) unsigned NOT NULL,
`section_id` int(10) unsigned NOT NULL,
`title` varchar(100) collate utf8_persian_ci NOT NULL,
`keywords` varchar(250) collate utf8_persian_ci NOT NULL,
`score` tinyint(3) unsigned NOT NULL,
`published` int(1) default '1',
PRIMARY KEY (`id`),
FULLTEXT KEY `title` (`title`,`keywords`),
FULLTEXT KEY `keywords` (`keywords`,`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_persian_ci AUTO_INCREMENT=1;