AgileApps Support Wiki Pre Release

Difference between revisions of "Data Truncation Error"

From AgileApps Support Wiki
imported>Aeric
imported>Aeric
Line 2: Line 2:
:* In a [[Picklist]] or [[Global Picklist]], a value available for selection might be longer than the maximum storage size for the field.
:* In a [[Picklist]] or [[Global Picklist]], a value available for selection might be longer 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.
:* 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).
:* The combination of all fields defined in the record could be larger than the maximum size of a MySQL row (65,535 bytes).

Revision as of 03:19, 18 March 2014

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 value available for selection might be longer 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 of a MySQL row (65,535 bytes).