4124
MariaDBERRORCriticalHIGH confidence

Column specification is too long for BLOB or TEXT

Production Risk

Low — DDL fails; no data is affected.

Why it happens
  1. 1A BLOB or TEXT column was defined with an explicit length that exceeds the maximum for the data type.

Fix

Use the appropriate BLOB/TEXT type for the required size

Why this works

Use TINYBLOB, BLOB, MEDIUMBLOB, or LONGBLOB depending on the maximum required data size.

What not to do

Sources
Official documentation ↗

MySQL 8.0 — 4124 ER_TOO_LONG_FIELDBLOB2

Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev

← All MariaDB errors