Query: Illegal Mix of Collations

[Max Hugen]

I created a simple query with 2 tables joined, but got the error:

Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='

The query:

SELECT
`contractitems`.`ContractItemType`
, `x_item_type`.`TypeAbbrev`
FROM
`cams_kpn_kps`.`contractitems`
INNER JOIN `cams_kpn_kps`.`x_item_type`
ON (`contractitems`.`ContractItemType` = `x_item_type`.`LineItemType`);

Both tables are currently Char Set=utf8, and Collation=utf8_unicode_ci.

However, one table, `contractitems`, was created as utf8_general_ci, and was later changed to utf8_unicode_ci - but I wouldn't have thought that should be a problem?

Max Hugen
Australia