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, <[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
