No results with fulltext search

[mwouters]

Hello,

I'm trying to create a search using fulltext search, but it does not return any values. I don't get an error when I execute following SQL, but nor a result:

SELECT ID AS blogID, titel, tekst, MATCH (titel, tekst) AGAINST ('Belgacom') AS ranking FROM blog WHERE MATCH (titel, tekst) AGAINST ('Belgacom')

I did use a word with more than 5 letters as you can see, and the word does not return 100 times in the text (so it would be ignored).. so it should find a result..

I have MySQL 4.1.18 installed.

Can it have something to do with the charset?
If I do an export of my table structure I get this:

CREATE TABLE `blog` (
  `ID` int(11) NOT NULL auto_increment,
  `datum` datetime NOT NULL default '0000-00-00 00:00:00',
  `titel` text collate latin1_general_ci NOT NULL,
  `auteur` int(11) NOT NULL default '0',
  `tekst` text collate latin1_general_ci NOT NULL,
  `foto1` text collate latin1_general_ci,
  `foto2` text collate latin1_general_ci,
  `foto3` text collate latin1_general_ci,
  UNIQUE KEY `ID` (`ID`),
  FULLTEXT KEY `titel` (`titel`,`tekst`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=5 ;

Thanks a lot for any help, I don't know what to do..

Mark.