Personally speaking, if the index > 256, it will lost the meaning of
indexing...
----- Original Message -----
From: "Jeremy D. Zawodny" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 30, 2001 3:06 PM
Subject: Re: ERROR 1170: BLOB column 'Url' used in key specification without
a key length
> On Mon, Jan 29, 2001 at 10:07:55PM -0800, Jeremy D. Zawodny wrote:
> >
> > ---snip---
> >
> > mysql> alter table Headlines modify Url TINYTEXT NOT NULL;
> >
> > ERROR 1170: BLOB column 'Url' used in key specification without a key
length
>
> Oh, okay. Now I understand.
>
> The max key length is 256, so I'd need to specify a number <= 256 in
> the index for that column. Hmm.
>
> It'd be really nice if the 256-character max key length wasn't a
> compile-time directive, but a run-time directive instead.
>
> Back to the drawing board a bit...
>
> Jeremy
> --
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 328-7878 Fax: (408) 530-5454
> Cell: (408) 439-9951
>
> ---------------------------------------------------------------------
> 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
>
>
>
---------------------------------------------------------------------
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
