471,090 Members | 1,361 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,090 software developers and data experts.

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

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
Jul 23 '05 #1
1 4644
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
---------------------------------------------------------------
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Wayno | last post: by
35 posts views Thread by fermineutron | last post: by
6 posts views Thread by kikapu | last post: by
11 posts views Thread by xenoix | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.