Re: ERROR 1005: Can't create table (errno: 150)

[Bill Cogan]

I experienced the same problem with the following...

CREATE TABLE `LANGUAGE` (
`LANGUAGE_CODE` varchar(20) NOT NULL,
`DESCRIPTION` varchar(255) default NULL,
PRIMARY KEY (`LANGUAGE_CODE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

I did find that if I remove 'ENGINE=InnoDB' it works, however I need InnoDB.



Edited 2 time(s). Last edit at 07/09/2010 12:30PM by Bill Cogan.