This thread is resolved. Here is a description of the problem and solution.
Problem: Solve the database error found in WPML -> Translation Management. The error message is: [Illegal mix of collations for operation 'UNION']
Solution: In the database, make sure that all table are using the same collation, for example ex.utf8mb4_unicode_ci.
This is the technical support forum for WPML - the multilingual WordPress plugin.
Everyone can read, but only WPML clients can post here. WPML team is replying on the forum 6 days per week, 22 hours per day.