The answer is that a fulltext index can only be built on a TEXT field. Even though the mysql documentation describes MEDIUMTEXT and LONGTEXT fields as 'BLOB or TEXT field that can hold..', they can not be used.
On Fri, 2003-06-06 at 09:36, H M Kunzmann wrote: > Hi all. > > I am running RH9.0 with MySQL 4.0.13 > > I am trying to create a fulltext index on a 1.5GB table with 400 > records. Whenever I do a create index (retried this a couple of times), > the index size grows to only 8MB before the index completes. When using > this index in fulltext searches, the search takes 1.5 Minutes. > > It seems to me like MySQL fails to generate the index correctly. > Is this a bug ? Does anyone know what's going on ? > > Thanks in advance. > Herbert -- Herbert Michael Kunzmann Binary Chaos Magician
signature.asc
Description: This is a digitally signed message part