Error Code : 1005 Can't create table '.\test\#sql-580_1.frm' (errno: 150)

[RoshiniKamath]

Errror Code:1005 Can't create table '.\test\#sql-580_1.frm' (errno: 150).....

I got this errror when i tried to create a foregin key.......Pleas e help me out on this error.....

[ck9663]

Could you post the T-SQL used to create the foreign key?


~~ CK

[nbiswas]

Change the CHARSET and COLLATE to utf8 and to utf8_general_ci and then try again.

Hope this will help