On Tue, 30 Jan 2001 10:04:47 -0800, [EMAIL PROTECTED]
([EMAIL PROTECTED]) wrote:
>This underscores a problem I have found with a few asp-driven
>college
>websites. Ungodly long URLs are used to address some of their pages.
>When I have inquired about this, and how to tell a friend where to
>find p
rt it to TINYTEXT.
>
> ---snip---
>
> mysql> alter table Headlines modify Url TINYTEXT NOT NULL;
>
> ERROR 1170: BLOB column 'Url' used in key specification without a key
> length
>
> ---snip---
>
> There is currently a unique index on the
On Mon, Jan 29, 2001 at 11:48:46PM -0800, Todd Grigsby wrote:
>
> > In this particular case it doesn't. I need to ensure that each URL
> > exists only once. And it is entirely possible to have a URL with 300
> > characters in it.
>
> Ok, how about encoding it? Come up with a simple compression
> In this particular case it doesn't. I need to ensure that each URL
> exists only once. And it is entirely possible to have a URL with 300
> characters in it.
Ok, how about encoding it? Come up with a simple compression algo that
uses 6 bits for every 8 bits, allowing for a-z, A-Z, slashes, do
On Tue, Jan 30, 2001 at 03:20:27PM +0800, Sam Wong wrote:
> Personally speaking, if the index > 256, it will lost the meaning of
> indexing...
Perhaps.
In this particular case it doesn't. I need to ensure that each URL
exists only once. And it is entirely possible to have a URL with 300
characte
; 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' use
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
Headlines modify Url TINYTEXT NOT NULL;
ERROR 1170: BLOB column 'Url' used in key specification without a key length
---snip---
There is currently a unique index on the Url column. The manual states
that one can have an index on a BLOB column:
http://www.mysql.com/doc/B/L/BLOB.html
S
