# Use a coherent county list, with ISO abbreviations in DB
**URL:** https://forum.mautic.org/t/use-a-coherent-county-list-with-iso-abbreviations-in-db/10816
**Category:** Ideas and Feature Requests
**Created:** [March 20, 2019, 10:16pm UTC](https://forum.mautic.org/t/use-a-coherent-county-list-with-iso-abbreviations-in-db/10816 "2019-03-20T22:16:17Z")
**Posts on this page:** 4
**Page:** 2
### Author:  [@mzagmajster](https://forum.mautic.org/u/mzagmajster)
#### Post date: [January 9, 2024, 8:45pm UTC](https://forum.mautic.org/t/use-a-coherent-county-list-with-iso-abbreviations-in-db/10816/21 "2024-01-09T20:45:57Z")
Name of the folder is probably wrong.
Make sure its named `MZagmajsterIsoCodeBundle`.
---
### Author:  [@precords](https://forum.mautic.org/u/precords)
#### Post date: [January 10, 2024, 9:10pm UTC](https://forum.mautic.org/t/use-a-coherent-county-list-with-iso-abbreviations-in-db/10816/22 "2024-01-10T21:10:04Z")
Yes indeed, the folder was not named that, now it is installed. Thank you!
---
### Author:  [@mneumann](https://forum.mautic.org/u/mneumann)
#### Post date: [August 13, 2024, 5:45pm UTC](https://forum.mautic.org/t/use-a-coherent-county-list-with-iso-abbreviations-in-db/10816/23 "2024-08-13T17:45:01Z")
I would extend this issue to include the country and region list. Countries are a painful issue, but it is manageable. When it comes to regions, the situation is worse. They are fairly well defined for most Western countries, but it is getting messy for the rest of the world. Several countries have wrong or outdated information when it comes to the Regions file. Some regions are simply missing. There are also some inconsistencies like Brazilian states are without accents, when the rest of the world has accents on their state names.
What would be needed:
1. Find an authoritative source like the CLDR charts, or maybe this libary which is based on CLDR: [GitHub - commerceguys/addressing: A PHP addressing library, powered by CLDR and Google's address data.](https://github.com/commerceguys/addressing)
2. To change those definitions at: [mautic/app/bundles/CoreBundle/Assets/json at 5.x · mautic/mautic · GitHub](https://github.com/mautic/mautic/tree/5.x/app/bundles/CoreBundle/Assets/json) to include a key/value pair, so that a two letter country code is associated to the country name, and the sames for the region definitions. Having this information, we could extend the API to accept in the country field the two letter code or the written out country name, and the same for the state definitions.
3. As a next step it can be even considered to save the two letter code instead of the name in the database. This would save some space, and would reduce also the number of database updates in case of name changes. I am not much familiar with Symphony, but I assume that such a change can be done just on the model layer, without the View and Logic being aware of any change in the database.
---
### Author:  [@mneumann](https://forum.mautic.org/u/mneumann)
#### Post date: [August 22, 2024, 11:39am UTC](https://forum.mautic.org/t/use-a-coherent-county-list-with-iso-abbreviations-in-db/10816/24 "2024-08-22T11:39:09Z")
I have opened a proposal here:
> **[Cleanup of Countries and Regions List and Implementation of 2 Digit Country...](https://community.mautic.org/processes/roadmap/f/4/proposals/52)**
>
> Has your proposal been discussed on the Mautic Forums already?https://forum.mautic.org/t/use-a-coherent-county-list-with-iso-abbreviations-in-db/10816Is your feature request related to a problem? Please describe.It is very challenging to add a...
Come and throw in your vote for that issue!
[Previous page](https://forum.mautic.org/t/use-a-coherent-county-list-with-iso-abbreviations-in-db/10816.md?page=1)