Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-18241

Change field length of civicrm_option_value.label from 255 to 512

    Details

    • Type: Improvement
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.6.14, 4.7.3
    • Fix Version/s: 4.7.5
    • Component/s: Core CiviCRM
    • Documentation Required?:
      None
    • Funding Source:
      Paid Issue Queue
    • Payment Status:
      Paid

      Description

      There might be several cases, where the length of this field might not be long enough.

      One relevant use case regards to internationalization, especially for postal and email greetings: As described here, this database field is used for smarty code, that populates the greeting fields with different values, whether communication_style is formal or familiar, or if the contact is female or male. This is relevant for many languages like spanish, german, italian.

      E.g.: "Sehr geehrte Frau Dr. Müller" versus "Sehr geehrte*r* Herr Meier":

      The entries for postal_greeting and email_greeting are stored in civicrm_option_value.label
      As we know by now, for many organizations the currently available 255 characters are not enough to store the necessary smarty syntax.

      We could simply change the database by ALTER TABLE CHANGE COLUMN for each CiviCRM install. However, we don't want that quick and dirty approach, that also might create trouble with upgrade scripts.

        Attachments

          Activity

            People

            • Assignee:
              rohan1990 Rohan Ramesh Katkar
              Reporter:
              detsieber Detlev Sieber
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 hour, 10 minutes
                1h 10m