Re: ERROR 1071: Specified key was too long. Max key length is 500

PM: > Hi, > > I'm wondering if anybody can help me decrypt what this error code is > referring to: > > ERROR 1071: Specified key was too long. Max key length is 500 > > This is the offending table creation script: > > CREATE TABLE `APPROVAL` ( >

Re: ERROR 1071: Specified key was too long. Max key length is 500

> PRIMARY KEY (`APPROVAL_ID`), > UNIQUE KEY `APPROVAL_APPLICATION` >(`APPROVAL_APPLICATION`,`FOREIGN_ID`,`FOREIGN_TYPE`) > >ERROR 1071: Specified key was too long. Max key length is 500 > >Is it the unique key I'm creating and if so how do I get around that? It's a

Re: ERROR 1071: Specified key was too long. Max key length is 500

Jon Wynacht <[EMAIL PROTECTED]> wrote on 02/01/2005 03:33:13 PM: > Hi, > > I'm wondering if anybody can help me decrypt what this error code is > referring to: > > ERROR 1071: Specified key was too long. Max key length is 500 > > This is the offending table

ERROR 1071: Specified key was too long. Max key length is 500

Hi, I'm wondering if anybody can help me decrypt what this error code is referring to: ERROR 1071: Specified key was too long. Max key length is 500 This is the offending table creation script: CREATE TABLE `APPROVAL` ( `APPROVAL_ID` mediumint(9) unsigned NOT NULL auto_incr