ISO country list, where art thou? - Wed Dec 30, 2009
While rewriting an old codebase of mine I decided that I should re-think how I was storing country data and switch to using country codes directly since those are standardized, immediately obvious when looking at the data and just as indexable by MySQL as numerical Indices. My old HTML piped through Awk generated MySQL table does not contain country codes so off to Google I went. Well somewhat surprisingly there are a lot of bad answers out there as to where to find an official list of country codes.
To hopefully safe time for those on the hunt, the official list of country codes can be found here:
The data is available in a number of formats including XML, plain text and viewable HTML.
topics: programming
Experienced PHP web developer.
$35 an hour, no job too small.
There is no replacement for integrity and experience.