AgileApps Support Wiki Pre Release

Data Truncation Error

From AgileApps Support Wiki
Revision as of 03:12, 18 March 2014 by imported>Aeric (Created page with "A data truncation error occurs when incoming data is too large to be stored. The error can occur for a number of reasons: :* In a Picklist or Global Picklist, a selected ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

A data truncation error occurs when incoming data is too large to be stored. The error can occur for a number of reasons:

  • In a Picklist or Global Picklist, a selected value could be larger than the maximum storage size for the field.
  • In a Multi Select Picklist or Multi Checkbox field, the combination of selected values could be larger than the maximum storage size for the field.
  • The combination of all fields defined in the record could be larger than the maximum size that MySQL can handle (6,5332 characters).