Re: key lengths

[Jeremy D. Zawodny]

On Wed, Mar 07, 2001 at 07:49:22AM -0600, Mike Thompson wrote:
> Yes, I've tries that here is the error I get.
> 
> Your MySQL connection id is 247 to server version: 3.23.33
> 
> mysql>  CREATE TABLE foo(
>     ->  id INT NOT NULL AUTO_INCREMENT,
>     ->  name BLOB NOT NULL,
>     ->  PRIMARY KEY(id),
>     ->  UNIQUE(name(500))
>     ->  );
> ERROR 1089: Incorrect sub part key. The used key part isn't a string or
> the used length is longer than the key part

No key part can be greater than 255 in lenght. But multi-part keys can
be longer (in total) than 255.

Jeremy
-- 
Jeremy D. Zawodny, <jzawodn@stripped>
Technical Yahoo - Yahoo Finance
Desk: [phone]    Fax: [phone]
Cell: [phone]