MySQL Forums
Forum List  »  MyISAM

Fulltext in MyISAM does not work with cyrillic
Posted by: Андрей Третяк
Date: January 29, 2016 09:13AM

I use table on innoDB . fulltext search is ok. But when I recreated table with MyISAM it is does not work. Fulltext index have 1 unique record on myisam and 3500 on innodb (with my data)
CREATE TABLE IF NOT EXISTS `PARS_TAB` (
`P_ID` int(8) unsigned NOT NULL,
`dt` date DEFAULT NULL,
`tp` tinyint(1) NOT NULL DEFAULT '0',
`cv` int(11) NOT NULL DEFAULT '0',
`URL` varchar(1000) COLLATE utf8_bin DEFAULT NULL,
`HEAD` varchar(5000) COLLATE utf8_bin DEFAULT NULL,
`DT_POST` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`PS_TEXT` text COLLATE utf8_bin
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*fulltext search is works*/
/* ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*fulltext search not works*/ */


--
ALTER TABLE `PARS_TAB`
ADD PRIMARY KEY (`P_ID`) USING BTREE,
ADD UNIQUE KEY `P_ID_2` (`P_ID`) USING BTREE,
ADD KEY `dt_i` (`dt`) USING BTREE,
ADD KEY `y_i` (`tp`),
ADD FULLTEXT KEY `H1` (`HEAD`); /*<-----cyrillic text*/
I tryed convert table, and base, and record type from utf8_bin to win1251 .. does not work
wtf? help

Options: ReplyQuote


Subject
Views
Written By
Posted
Fulltext in MyISAM does not work with cyrillic
2643
January 29, 2016 09:13AM


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.