In article <[EMAIL PROTECTED]>, Michael Widenius <[EMAIL PROTECTED]> writes >I just tested this with the upcoming MySQL 4.0.1: > >mysql> create table t1 (a text); >Query OK, 0 rows affected (0.01 sec) > >mysql> CREATE INDEX t1 ON t1(a); >ERROR 1170: BLOB column 'a' used in key specification without a key length > >If you don't get the same error with your MySQL version, then it's >likely that this error is already fixed.
Monty, Sinisa already replied saying it was fixed in 4.0.1. :) ...although the table which has been troublesome crashed again earlier today, as yet cause unknown *sigh* Thanks for your help! -- Matt Johnson <[EMAIL PROTECTED]> Developer AVSIM Online! --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php