[tz] Two elements in list of assigned ISO 3166-1 alpha-2 codes not contained in zone.tab

[Ian Abbott]

On 12/05/2012 05:23, Tobias Conradi wrote:
> 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_elements
>
> 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!

Well done, but you did all that after trying to convince us list 
subscribers that you had no idea how to find out which of several text 
files in a directory contained a text string you were looking for?

-- 
-=( Ian Abbott @ MEV Ltd.    E-mail: <abbotti at mev.co.uk>        )=-
-=( Tel: +44 (0)161 477 1898   FAX: +44 (0)161 718 3587         )=-