retitle 565240 Please provide up to date country data tags 565240 patch thanks
As noted in the initial bug report “Taiwan, province of China” might not be the most accurate description of the TW ISO 3166 code. Someone also recently asked on IRC: can you change the country "Yugoslavia" to "Serbia"? Also add "Montenegro". After a quick look at the source, the src/db/200403251.sql is indeed outdated (as its name suggest), please find attached an updated version generated with the simple Perl code also attached, that relies on a single isoquery call. I didn't try to keep the Country name uppercase since I believe it was a mistake in the first place, but it can be restored using uc() if you wish. Please also note that the iso-codes package provide an easy way to translate these country names (with dgettext()) and isoquery can also be used in that purpose. I don't know if relying in a static country_code is the most accurate way to handle this list (since it doesn't offer an easy way to keep the data up to date), nor if it's better to keep the translated country names in the database or to translate them when generating the box, so I didn't yet propose a patch for the translation, but I'd be happy to if you provide some guidance here. Regards David
200403251.sql
Description: application/sql
ffcountries.pl
Description: Perl program
signature.asc
Description: OpenPGP digital signature
