• lightweight replied to the topic Use a coherent county list, with ISO abbreviations in DB in the forum Ideas 3 months, 2 weeks ago

    Given how deeply embedded this country stuff is within their data schema (they store country names in the DB, rather than indices into a country table!) it’d be a total nightmare to fix this architectural problem… So, I feel some sympathy for the Mautic dev team having to wrestle with such an unfortunate early decision, no doubt made out of expedience, to define their own country list… 🙁

    For what it’s worth, I wrote a parser (in PHP) to create the mapping between an ISO country list (using 2 letter country codes mapped to full names) and the Mautic-specific country list… note, it’s not a strict 1-to-1 mapping.