To aid the discussion on how much extra work it is to map all currently assigned ISO 3166-1 alpha-2 codes to at least one zone, I did: 1) import a) a list of ISO 3166-1 codes http://en.wikipedia.org/wiki/ISO_3166-1_alpha-2#Officially_assigned_code_ele... b) the list of ISO 3166-1 codes from tzdata2012c/zone.tab 2) performed the query SELECT DISTINCT(tz_zonelist.iso_3166_1), tz_countrylist.iso_3166_1 FROM tz_countrylist LEFT JOIN tz_zonelist ON tz_countrylist.iso_3166_1= tz_zonelist.iso_3166_1 ORDER BY `tz_zonelist`.`iso_3166_1` ASC 3) obtained the results iso_3166_1 iso_3166_1 NULL HM NULL BV AD AD ... That means the only ISO 3166-1 codes not mapped seem to be HM and BV. Any corrections welcome! -- Tobias Conradi Rheinsberger Str. 18 10115 Berlin Germany http://tobiasconradi.com/