AgileApps Support Wiki Pre Release

Difference between revisions of "Data Truncation Error"

From AgileApps Support Wiki
imported>Aeric
imported>Aeric
 
(2 intermediate revisions by the same user not shown)
Line 2: Line 2:
:* 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 default maximum size is 32 characters.  
::* The default maximum size is 32 characters.  
::* But 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.  
::* 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.
:* Even in a single-selection [[Picklist]] or [[Global Picklist]], a value available for selection might be longer than the maximum storage size for the field.
::* 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).
:* The combination of all fields defined in the record could be larger than the maximum size of a MySQL row (65,535 bytes).
<noinclude>
<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:

  • 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).