Search äüö and 大
Hi !
I can't findout problem with fulltext searching those signs. So. My table looks like:
CREATE TABLE IF NOT EXISTS `test` (
`data` varchar(100) NOT NULL,
FULLTEXT KEY `data` (`data`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `test` (`data`) VALUES
('äüö äüö.gif'),
('大 大.gif');
When I try something like:
SELECT * FROM test WHERE MATCH(test.data) AGAINST("大")
or
SELECT * FROM test WHERE MATCH(test.data) AGAINST("äüö")
I get nothing. What I do wrong ?
Subject
Views
Written By
Posted
Search äüö and 大
4162
August 21, 2009 01:00PM
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.