Help Center/ ROMA Connect/ Troubleshooting/ Common Data Integration Tasks/ Error Message "Illegal mix of collations for operation 'UNION'" Is Displayed at the Source Database During MySQL-to-MySQL Data Integration
Updated on 2022-02-21 GMT+08:00

Error Message "Illegal mix of collations for operation 'UNION'" Is Displayed at the Source Database During MySQL-to-MySQL Data Integration

Cause Analysis

According to the data source view at the source, union is used in the view definition statement. However, the encoding of the fields on both sides of union is inconsistent.

Solution

Use CONVERT to unify the encoding for fields, for example, CONVERT (ID USING utf8) AS ID.