mysql建表errno:150

CREATE TABLE `product_card` (
`ID` VARCHAR(32) COLLATE latin1_swedish_ci NOT NULL DEFAULT '',
`CARD_NO` VARCHAR(20) COLLATE latin1_swedish_ci DEFAULT NULL,
`CARD_PWD` VARCHAR(50) COLLATE latin1_swedish_ci DEFAULT NULL,
`STATUS` VARCHAR(2) COLLATE latin1_swedish_ci DEFAULT NULL,
`money` INTEGER(11) DEFAULT NULL,
`product_id` VARCHAR(32) COLLATE utf8_general_ci DEFAULT NULL,
`createDate` DATETIME DEFAULT NULL,
`modifyDate` DATETIME DEFAULT NULL,
`PRICE` DECIMAL(15,5) DEFAULT NULL,
`ORDER_ID` VARCHAR(32) COLLATE [color=red]utf8_general_ci[/color] DEFAULT NULL,
PRIMARY KEY (`ID`),
KEY `FK60163F61F4E7D111` (`product_id`),
KEY `FK32425F4E7D345341` (`ORDER_ID`),
CONSTRAINT `FK60163F61F4E7D111` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`),
CONSTRAINT `FK32425F4E7D345341` FOREIGN KEY (`ORDER_ID`) REFERENCES `orders` (`id`)
)ENGINE=[color=red]InnoDB DEFAULT CHARSET=utf8[/color];


出现这种错误一定要注意红色字体所表，外建所在字段字符编码与参引表的字符编码相同
请关注下我的个人网站，谢谢！[url]http://www.koala.net.cn/[/url]