Country ISO List #4651

New issue

Open

opened 2026-02-20 16:21:18 -05:00 by deekerman · 0 comments

deekerman commented

2026-02-20 16:21:18 -05:00

Owner

Originally created by @tsmgeek on GitHub (Nov 8, 2021).

Originally assigned to: @samus-aran on GitHub.

github.com/salesagility/SuiteCRM@a4afbded55/include/language/en_us.lang.php (L2232)

This country list does not follow ISO-3166-1, some countries like...

BOSNIA -> Bosnia and Herzegovina
VIETNAM -> Viet Nam
KOREA, SOUTH -> South Korea or Korea, Republic of
KOREA -> North Korea or Korea (Democratic People's Republic of),

Problem is handling historical assignments.

Also all countries are uppercased, it would be better if this list was properly formatted.
I propose just changing the display names to their correct ones and leaving the internal keys as they are for now.

Even some of the translation packs are using the correct names, they just can not change the internal keys even though they are clearly wrong.

Mabey a migration to ISO codes being stored internally for any column that is a country name and just translate on display, internally a method to decode a country code to ISO2/ISO3/Short/Long names etc.
Some modules such as accounts always store the country name as entered, rather than ask user to select one from a list and then have consistency across the system.

ps. this has come to light as we post data in via the API for accounts and it does not validate the country name against the list, it will save whatever you supply.

https://en.wikipedia.org/wiki/ISO_3166-1

Originally created by @tsmgeek on GitHub (Nov 8, 2021). Originally assigned to: @samus-aran on GitHub. https://github.com/salesagility/SuiteCRM/blob/a4afbded5514f64e11e9d4eaf995bfe96fda86c9/include/language/en_us.lang.php#L2232 This country list does not follow ISO-3166-1, some countries like... - `BOSNIA -> Bosnia and Herzegovina` - `VIETNAM -> Viet Nam` - `KOREA, SOUTH -> South Korea` or `Korea, Republic of` - `KOREA -> North Korea` or `Korea (Democratic People's Republic of)`, Problem is handling historical assignments. Also all countries are uppercased, it would be better if this list was properly formatted. I propose just changing the display names to their correct ones and leaving the internal keys as they are for now. Even some of the translation packs are using the correct names, they just can not change the internal keys even though they are clearly wrong. Mabey a migration to ISO codes being stored internally for any column that is a country name and just translate on display, internally a method to decode a country code to ISO2/ISO3/Short/Long names etc. Some modules such as accounts always store the country name as entered, rather than ask user to select one from a list and then have consistency across the system. ps. this has come to light as we post data in via the API for accounts and it does not validate the country name against the list, it will save whatever you supply. https://en.wikipedia.org/wiki/ISO_3166-1