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 |
||
| (7 intermediate revisions by the same user not shown) | |||
| 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 [[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 | ::* The default maximum size is 32 characters. | ||
::* If all values are selected, the number of characters required for N labels is the sum of the sizes of all N labels plus N-1 commas. | |||
::* That number can be reduced only if there are combinations of values that are never selected. | |||
:* In a single-selection [[Picklist]], [[Global Picklist]], or [[Dependent Picklist]] a value available for selection might be longer than the maximum storage size specified 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). | |||
<noinclude> | |||
[[Category:Troubleshooting]] | |||
</noinclude> | |||
Latest revision as of 23:32, 2 May 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 Multi Select Picklist or Multi Checkbox field, the combination of selected values could be larger than the maximum storage size for the field.
- The default maximum size is 32 characters.
- If all values are selected, the number of characters required for N labels is the sum of the sizes of all N labels plus N-1 commas.
- That number can be reduced only if there are combinations of values that are never selected.
- In a single-selection Picklist, Global Picklist, or Dependent Picklist a value available for selection might be longer than the maximum storage size specified 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).