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_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!
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@mev.co.uk> )=- -=( Tel: +44 (0)161 477 1898 FAX: +44 (0)161 718 3587 )=-