Hi! On Jun 13, H M Kunzmann wrote: > 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.
No, this is wrong. Any xxxTEXT field can be used in FULLTEXT index. TEXT, MEDIUMTEXT, LONGTEXT, TINYTEXT - they all work. Regards, Sergei -- MySQL Development Team __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
