Increase size of mysql field in export table for column with CRM_Utils_Type::T_INT type
Overview
Increase size of mysql field in export table for column with CRM_Utils_Type::T_INT type.
Example use-case
- Change label of phone type "Mobile" to "Telefon komórkowy" (which is Polish translation with 18 length)
- Search for contacts with this phone type
- Make an action "Export contacts"
Current behaviour
Current size is VARCHAR(16). The db error occurs:
[nativecode=1406 ** Data too long for column 'phone_type_id' at row 1]
Proposed behaviour
Increasing size to VARCHAR(64) allows exporting works fine with option labels longer than 16 chars. Not only built-in dictionaries like phone types but also for custom options/custom fields.
Comments
To be more precise I should increase the length to VARCHAR(512) because of civicrm_option_value.label definition.