SQL error 1366 Incorrect String Values Error Raised By OGG Replicat When Migrating Data Among Database With Different Character Sets (Doc ID 2957835.1)

Last updated on JULY 20, 2024

Applies to:

Oracle GoldenGate - Version 19.1.0.0.4 and later
Information in this document applies to any platform.

SQL error 1366 Incorrect String Values Error were raised by OGG Replicat when migrating data from Oracle Database with GBK character set to MySQL Database with with utf8mb4 character set.
This problem could be avoided by skipping the data rows of Chinese Characters.

	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.