MySQL Replication Breaks With Error 1677: Column .. of Table '...' Cannot Be Converted (Doc ID 2037712.1)

Last updated on SEPTEMBER 10, 2023

Applies to:

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

MySQL replication breaks with error 1677, for example:

This can be triggered by changes such as:

changing the default character set on either the source or the replica, but not the other
changing the table or column definition on the replica
changing the table or column definition on the source but not having it replicate
creating the table with different schema on the source and replica

	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.