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
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.
Parent topic: Common Data Integration Tasks
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.