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 KE
> From: "Mike Thompson" <[EMAIL PROTECTED]>
> To: "mysql" <[EMAIL PROTECTED]>
> Sent: Tuesday, March 06, 2001 1:51 PM
> Subject: key lengths
>
> > How is key length for a table defined? It seems that the default is 255
> > bytes, but in t
gt; id INT NOT NULL AUTO_INCREMENT,
> name BLOB NOT NULL,
> PRIMARY KEY(id),
> UNIQUE(name(500))
> );
>
> Pat...
> [EMAIL PROTECTED]
>
> - Original Message -
> From: "Mike Thompson" <[EMAIL PROTECTED]>
> To: "mysql" <[EMAIL
;Mike Thompson" <[EMAIL PROTECTED]>
To: "mysql" <[EMAIL PROTECTED]>
Sent: Tuesday, March 06, 2001 1:51 PM
Subject: key lengths
> How is key length for a table defined? It seems that the default is 255
> bytes, but in the online docs it mentions 500 byte keys.
How is key length for a table defined? It seems that the default is 255
bytes, but in the online docs it mentions 500 byte keys. I happen to
have some very long case sensitive strings that I need to use as keys,
but mysql complains when I try to create a table as such
CREATE TABLE foo(
