MySQL Forums
Forum List  »  Full-Text Search

Search äüö and 大
Posted by: Jan Koprowski
Date: August 21, 2009 01:00PM

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 ?

Options: ReplyQuote


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.