MySQL Forums
Forum List  »  Full-Text Search

Re: Full-Text Search not work in new version!
Posted by: mahmud mofrad
Date: August 23, 2012 12:28AM

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;

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Full-Text Search not work in new version!
2058
August 23, 2012 12:28AM
2720
August 25, 2012 01:18AM


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.