Increase size of mysql field in export table for column with CRM_Utils_Type::T_INT type
Increase size of mysql field in export table for column with CRM_Utils_Type::T_INT type.
- 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 size is VARCHAR(16). The db error occurs:
[nativecode=1406 ** Data too long for column 'phone_type_id' at row 1]
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.
To be more precise I should increase the length to VARCHAR(512) because of civicrm_option_value.label definition.