Difference between revisions of "Data Truncation Error"
From AgileApps Support Wiki
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 ...") |
imported>Aeric |
||
| Line 1: | Line 1: | ||
A data truncation error occurs when incoming data is too large to be stored. The error can occur for a number of reasons: | 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 | :* 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 that MySQL can handle (6,5332 characters). | ||
Revision as of 03:14, 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 that MySQL can handle (6,5332 characters).