ERROR 1071 (42000): Specified key was too long; max key length is 1024 bytes

[Neil Zanella]

Hello,

I have a CREATE TABLE statement which runs fine under PostgreSQL. However,
when I run the statement under MySQL I get the following error message:

ERROR 1071 (42000): Specified key was too long; max key length is 1024 bytes

I would like to know whether there is some way of bypassing this
MySQL-specific restriction on key size, perhaps by changing the
table type or some global parameter.

Thanks for your help with this issue,

Sincerey,

Neil Zanella

[Jeff North]

On 30 May 2005 05:01:43 -0700, in mailing.database.mysql
nz******@cs.mun.ca (Neil Zanella) wrote:

| Hello,
|
| I have a CREATE TABLE statement which runs fine under PostgreSQL. However,
| when I run the statement under MySQL I get the following error message:
|
| ERROR 1071 (42000): Specified key was too long; max key length is 1024 bytes
|
| I would like to know whether there is some way of bypassing this
| MySQL-specific restriction on key size, perhaps by changing the
| table type or some global parameter.
|
| Thanks for your help with this issue,

Show us the create statement.
---------------------------------------------------------------
jn******@yourpantsyahoo.com.au : Remove your pants to reply
---------------------------------------------------------------