InnoDB and joining tables - problem with this

I have two databases, tvguide and episodes1.

Both are InnoDB, and I use Phpmyadmin to edit them.

I tried creating a foreign key between开发者_如何学C the "episode" field of episodes1 and tvguide, and this error message came up:

Error creating foreign key (check data types) : episode

How can I fix this and ensure both tables join? I have InnoDB set for both databases, so this shouldn't happen, but why?

It may be that you have defined the 'episodes' column differently in each table. That could cause the operation to fail. Perhaps you could post (possibly trimmed versions of) your table definitions here. Then we can say for certain.