Illegal mix of collections of operation 'UNION'

I got an Illegal mix of collections of operation 'UNION' when I try to compare an AWS MySQL to a localhost MySQL. 

Comments

  • PeterLPeterL Posts: 1 New member
    Same problem here, and this appears to be the bit that causes the error:

    SELECT 

    TRIGGER_NAME is utf8_general_ci, while TABLE_NAME is utf8_tolower_ci [at least in MySQL 8.0.16]. This basically makes the tool unusable, so it'd be nice to get it fixed...
  • I also get the error "Illegal mix of collations for operation 'UNION'" when trying to compare to a local mysql (version 
    8.0.18)
    database. This will occur even if it is a completely empty database. I've tried all options available in the mysqlcompare tool, nothing helps. 
    As PeterL notes, this makes the tool unusable.
Sign In or Register to comment.