Fulltext in MyISAM does not work with cyrillic
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
Subject
Views
Written By
Posted
Fulltext in MyISAM does not work with cyrillic
2857
January 29, 2016 09:13AM
1528
January 30, 2016 10:20AM
1637
February 01, 2016 02:04AM
1469
February 02, 2016 09:33PM
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.