Foreign Key on text field

[Sudip Shekhawat]

Hi,

I am using MySQL 4.0.17. When I try to create a foreign key on a field of 
the type text, I get this error:

040609 15:02:31 Error in foreign key constraint of table db_name/tb_name:
There is no index in the table db_name/tb_name where the columns appear
as the first columns. Constraint:
FOREIGN KEY (CEA_key) REFERENCES relation (CEA_key) ON DELETE CASCADE
)TYPE=InnoDB;


Can I create a foreign key on the text field?? In the parent table the 
parent column has a index of length 64.

Thanks
Sudip

_________________________________________________________________
Looking to buy a house? Get informed with the Home Buying Guide from MSN 
House & Home. http://coldwellbanker.msn.com/