Replica Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'UNION' Error_code: MY-001267 (Doc ID 2556649.1)

Last updated on MARCH 03, 2024

Applies to:

MySQL Server - Version 8.0 and later
Information in this document applies to any platform.

MySQL Replication failed with error below:

Upgrade replica database from 5.7 to 8.0 or replication between databases with different default character sets.

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

Symptoms

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.