MySQL LoadDump() Fails With Error - "Error BLOB, TEXT, GEOMETRY or JSON column 'xxx' can't have a default value" (Doc ID 2866987.1)

Last updated on JUNE 03, 2024

Applies to:

MySQL Database Service - Version N/A to N/A
MySQL Server - Version 8.0 to 8.0 [Release 8.0]
MySQL Server - Version 5.0 and later
Information in this document applies to any platform.

Symptoms

MySQL LoadDump() Fails With Error BLOB, TEXT, GEOMETRY or JSON column 'XYZ' can't have a default value

Changes

Cause

	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

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