List:General Discussion« Previous MessageNext Message »
From:Dainis Polis Date:June 2 2004 7:51am
Subject:fulltext in boolean mode with utf8
View as plain text  
Hi All!

May be anyone can help in this situation:

Version: 4.1.2-alpha-nightly-20040523-log
OS : Linux

Show create table TEST:

CREATE TABLE `TEST` (
`ID` int(10) unsigned NOT NULL auto_increment,
`saturs` char(255) default NULL,
PRIMARY KEY (`ID`),
FULLTEXT KEY `sat` (`saturs`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8

insert into TEST (ID,saturs) values (1, _cp1257 'pa-r par par')
insert into TEST (ID,saturs) values (2, _cp1257 'par par par')

select * from TEST:
ID saturs
1 pÄ?r par par
2 par par par


select * from TEST where match(saturs) against('par' in boolean mode) :
no rows

_________________

So while no rows in last search?













Thread
fulltext in boolean mode with utf8Dainis Polis2 Jun