RE: [PHP-DB] BLOB index

> -----Original Message----- > From: Adv. Systems Design [mailto:asd_2000@yahoo.com] > Sent: Thursday, August 24, 2000 11:21 AM > To: php-db@lists.php.net > Subject: [PHP-DB] BLOB index > > > I'm trying to index a TEXT field using PHPMyAdmin and > I keep getting: BLOB column 'keywords' used in key > specification without a key length. > > I tried specifying a key length (768)(this is a read > only table and I built a keyword field to improve > searching, and the keywords are not longer than > 400-500 characters in the extreme) and it did not > work...How can I index (or do I need to index) this > field? BLOB and TEXT columns wind up being a special case when it comes to indexing. In particular, the MySQL manual says "For BLOB and TEXT columns, you must index a prefix of the column, you cannot index the entire thing." See http://www.mysql.com/documentation/mysql/commented/manual.php?section=Indexe s for the full nitty-gritty. --- Mark Roedel | "Blessed is he who has learned to laugh Systems Programmer | at himself, for he shall never cease LeTourneau University | to be entertained." Longview, Texas, USA | -- John Powell