I seem to recall that foreign keys cannot reference tables with different character sets and collation.
I seem to recall that foreign keys cannot reference tables with different character sets and collation.