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

country::multi_select is limited due to varchar(255)

    Details

    • Type: Bug
    • Status: Open
    • Priority: Trivial
    • Resolution: Unresolved
    • Affects Version/s: 4.4.9
    • Fix Version/s: Unscheduled
    • Component/s: Core CiviCRM
    • Labels:
      None
    • Versioning Impact:
      Patch (backwards-compatible bug fixes)
    • Documentation Required?:
      None

      Description

      When new custom data set is created and uses a field with country::multi select type data, the table is set up with type VARCHAR(255).

      This limits the number of countries selectable to around 50.

      This can be confirmed on the demo site (try adding a custom set with a field of type country > multiselect then adding all countries to the field via editing a contact)

      changing the columns 'type' to VARCHAR(1024) fixes the problem.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              marshCircle Martin Castle
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: