Search Postgresql Archives

Re: List of countries (WAS: National Number to text conversion)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Nis Jorgensen wrote:
brian ally wrote:

I was thinking the same. But Bob's reply has me wondering if there are any online resources for this sort of thing. Specifically, i have a look-up table, with most (possibly all - i don't know) countries' 2-letter ISO codes and english names. Just this weekend, i've learned that i'll require the names in french, as well. I'd thought about feeding the names to Babelfish, but, if such a list exists somewhere that'd be a real time saver.


Do you mean something like

http://www.iso.org/iso/en/prods-services/iso3166ma/02iso-3166-code-lists/list-fr1-semic.txt

Unfortunately the list is in ALL CAPS. I believe I can extract a decapitated version from one of my systems, if you have time to wait until tomorrow.

/Nis


Thanks, Nis. Here's my revised list, using those (errors of letter-case entirely my own, owing to my hazy understanding of capitilisation for hyphenated french nouns):

ISO-3166	Name (en)	Name(fr)
'AF'	'Afghanistan'	'Afghanistan'
'AL'	'Albania'	'Albanie'
'DZ'	'Algeria'	'Algérie'
'AS'	'American Samoa'	'Samoa Américaines'
'AD'	'Andorra'	'Andorre'
'AO'	'Angola'	'Angola'
'AI'	'Anguilla'	'Anguilla'
'AQ'	'Antarctica'	'Antarctique'
'AG'	'Antigua and Barbuda'	'Antigua-et-barbuda'
'AR'	'Argentina'	'Argentine'
'AM'	'Armenia'	'Arménie'
'AW'	'Aruba'	'Aruba'
'AX'	'Åland Islands'	'Åland, Îles'
'AU'	'Australia'	'Australie'
'AT'	'Austria'	'Autriche'
'AZ'	'Azerbaijan'	'Azerbaïdjan'
'BS'	'Bahamas'	'Bahamas'
'BH'	'Bahrain'	'Bahreïn'
'BD'	'Bangladesh'	'Bangladesh'
'BB'	'Barbados'	'Barbade'
'BY'	'Belarus'	'Bélarus'
'BE'	'Belgium'	'Belgique'
'BZ'	'Belize'	'Belize'
'BJ'	'Benin'	'Bénin'
'BM'	'Bermuda'	'Bermudes'
'BT'	'Bhutan'	'Bhoutan'
'BO'	'Bolivia'	'Bolivie'
'BA'	'Bosnia and Herzegovina'	'Bosnie-herzégovine'
'BW'	'Botswana'	'Botswana'
'BV'	'Bouvet Island'	'Bouvet, Île'
'BR'	'Brazil'	'Brésil'
'IO' 'British Indian Ocean Territory' 'Océan Indien, Territoire Britannique de l''
'BN'	'Brunei Darussalam'	'Brunéi Darussalam'
'BG'	'Bulgaria'	'Bulgarie'
'BF'	'Burkina Faso'	'Burkina Faso'
'BI'	'Burundi'	'Burundi'
'KH'	'Cambodia'	'Cambodge'
'CM'	'Cameroon'	'Cameroun'
'CA'	'Canada'	'Canada'
'CV'	'Cap Verde'	'Cap-vert'
'KY'	'Cayman Islands'	'Caïmanes, Îles'
'CF'	'Central African Republic'	'Centrafricaine, République'
'TD'	'Chad'	'Tchad'
'CL'	'Chile'	'Chili'
'CN'	'China'	'Chine'
'CX'	'Christmas Island'	'Christmas, Île'
'CC'	'Cocos (Keeling) Islands'	'Cocos (Keeling), Îles'
'CO'	'Colombia'	'Colombie'
'KM'	'Comoros'	'Comores'
'CD' 'Congo, Democratic Republic of the' 'Congo, la République Démocratique du'
'CG'	'Congo, Republic of'	'Congo'
'CK'	'Cook Islands'	'Cook, Îles'
'CR'	'Costa Rica'	'Costa Rica'
'CI'	'Côte d'Ivoire'	'Côte D'ivoire'
'HR'	'Croatia/Hrvatska'	'Croatie'
'CU'	'Cuba'	'Cuba'
'CY'	'Cyprus'	'Chypre'
'CZ'	'Czech Republic'	'Tchèque, République'
'DK'	'Denmark'	'Danemark'
'DJ'	'Djibouti'	'Djibouti'
'DM'	'Dominica'	'Dominique'
'DO'	'Dominican Republic'	'Dominicaine, République'
'TL'	'East Timor'	'Timor-Leste'
'EC'	'Ecuador'	'Équateur'
'EG'	'Egypt'	'Égypte'
'SV'	'El Salvador'	'El Salvador'
'GQ'	'Equatorial Guinea'	'Guinée équatoriale'
'ER'	'Eritrea'	'Érythrée'
'EE'	'Estonia'	'Estonie'
'ET'	'Ethiopia'	'Éthiopie'
'FK'	'Falkland Islands (Malvina)'	'Falkland, Îles (Malvinas)'
'FO'	'Faroe Islands'	'Féroé, Îles'
'FJ'	'Fiji'	'Fidji'
'FI'	'Finland'	'Finlande'
'FR'	'France'	'France'
'GF'	'French Guiana'	'Guyane Française'
'PF'	'French Polynesia'	'Polynésie Française'
'TF'	'French Southern Territories'	'Terres Australes Françaises'
'GA'	'Gabon'	'Gabon'
'GM'	'Gambia'	'Gambie'
'GE'	'Georgia'	'Géorgie'
'DE'	'Germany'	'Allemagne'
'GH'	'Ghana'	'Ghana'
'GI'	'Gibraltar'	'Gibraltar'
'GR'	'Greece'	'Grèce'
'GL'	'Greenland'	'Groenland'
'GD'	'Grenada'	'Grenade'
'GP'	'Guadeloupe'	'Guadeloupe'
'GU'	'Guam'	'Guam'
'GT'	'Guatemala'	'Guatemala'
'GG'	'Guernsey'	'Guernesey'
'GN'	'Guinea'	'Guinée'
'GW'	'Guinea-Bissau'	'Guinée-bissau'
'GY'	'Guyana'	'Guyana'
'HT'	'Haiti'	'Haïti'
'HM'	'Heard and McDonald Islands'	'Heard, Île et Mcdonald, Îles'
'VA' 'Holy See (City Vatican State)' 'Saint-siège (État de la Cité du Vatican)'
'HN'	'Honduras'	'Honduras'
'HK'	'Hong Kong'	'Hong-kong'
'HU'	'Hungary'	'Hongrie'
'IS'	'Iceland'	'Islande'
'IN'	'India'	'Inde'
'ID'	'Indonesia'	'Indonésie'
'IR'	'Iran (Islamic Republic of)'	'Iran, République Islamique d''
'IQ'	'Iraq'	'Iraq'
'IE'	'Ireland'	'Irlande'
'IM'	'Isle of Man'	'Île de Man'
'IL'	'Israel'	'Israël'
'IT'	'Italy'	'Italie'
'JM'	'Jamaica'	'Jamaïque'
'JP'	'Japan'	'Japon'
'JE'	'Jersey'	'Jersey'
'JO'	'Jordan'	'Jordanie'
'KZ'	'Kazakhstan'	'Kazakhstan'
'KE'	'Kenya'	'Kenya'
'KI'	'Kiribati'	'Kiribati'
'KP' 'Korea, Democratic People's Republic' 'Corée, République Populaire Démocratique de'
'KR'	'Korea, Republic of'	'Corée, République De'
'KW'	'Kuwait'	'Koweït'
'KG'	'Kyrgyzstan'	'Kirghizistan'
'LA' 'Lao People's Democratic Republic' 'Lao, République Démocratique Populaire'
'LV'	'Latvia'	'Lettonie'
'LB'	'Lebanon'	'Liban'
'LS'	'Lesotho'	'Lesotho'
'LR'	'Liberia'	'Libéria'
'LY'	'Libyan Arab Jamahiriya'	'Libyenne, Jamahiriya Arabe'
'LI'	'Liechtenstein'	'Liechtenstein'
'LT'	'Lithuania'	'Lituanie'
'LU'	'Luxembourg'	'Luxembourg'
'MO'	'Macau'	'Macao'
'MK' 'Macedonia, Former Yugoslav Republic' 'Macédoine, l'ex-république Yougoslave de'
'MG'	'Madagascar'	'Madagascar'
'MW'	'Malawi'	'Malawi'
'MY'	'Malaysia'	'Malaisie'
'MV'	'Maldives'	'Maldives'
'ML'	'Mali'	'Mali'
'MT'	'Malta'	'Malte'
'MH'	'Marshall Islands'	'Marshall, Îles'
'MQ'	'Martinique'	'Martinique'
'MR'	'Mauritania'	'Mauritanie'
'MU'	'Mauritius'	'Maurice'
'YT'	'Mayotte'	'Mayotte'
'MX'	'Mexico'	'Mexique'
'FM'	'Micronesia, Federal State of'	'Micronésie, États Fédérés de'
'MD'	'Moldova, Republic of'	'Moldova, République de'
'MC'	'Monaco'	'Monaco'
'MN'	'Mongolia'	'Mongolie'
'MS'	'Montserrat'	'Montserrat'
'MA'	'Morocco'	'Maroc'
'MZ'	'Mozambique'	'Mozambique'
'MM'	'Myanmar'	'Myanmar'
'NA'	'Namibia'	'Namibie'
'NR'	'Nauru'	'Nauru'
'NP'	'Nepal'	'Népal'
'NL'	'Netherlands'	'Pays-bas'
'AN'	'Netherlands Antilles'	'Antilles Néerlandaises'
'NC'	'New Caledonia'	'Nouvelle-calédonie'
'NZ'	'New Zealand'	'Nouvelle-zélande'
'NI'	'Nicaragua'	'Nicaragua'
'NE'	'Niger'	'Niger'
'NG'	'Nigeria'	'Nigéria'
'NU'	'Niue'	'Niué'
'NF'	'Norfolk Island'	'Norfolk, Île'
'MP'	'Northern Mariana Islands'	'Mariannes Du Nord, Îles'
'NO'	'Norway'	'Norvège'
'OM'	'Oman'	'Oman'
'PK'	'Pakistan'	'Pakistan'
'PW'	'Palau'	'Palaos'
'PS'	'Palestinian Territories'	'Palestinien Occupé, Territoire'
'PA'	'Panama'	'Panama'
'PG'	'Papua New Guinea'	'Papouasie-nouvelle-guinée'
'PY'	'Paraguay'	'Paraguay'
'PE'	'Peru'	'Pérou'
'PH'	'Philippines'	'Philippines'
'PN'	'Pitcairn Island'	'Pitcairn'
'PL'	'Poland'	'Pologne'
'PT'	'Portugal'	'Portugal'
'PR'	'Puerto Rico'	'Porto Rico'
'QA'	'Qatar'	'Qatar'
'RE'	'Reunion Island'	'Réunion'
'RO'	'Romania'	'Roumanie'
'RU'	'Russian Federation'	'Russie, Fédération de'
'RW'	'Rwanda'	'Rwanda'
'KN'	'Saint Kitts and Nevis'	'Saint-kitts-et-nevis'
'LC'	'Saint Lucia'	'Sainte-lucie'
'VC'	'Saint Vincent and the Grenadines'	'Saint-vincent-et-les Grenadines'
'SM'	'San Marino'	'Saint-marin'
'ST'	'São Tomé et Principe'	'Sao Tomé-et-principe'
'SA'	'Saudi Arabia'	'Arabie Saoudite'
'SN'	'Senegal'	'Sénégal'
'SC'	'Seychelles'	'Seychelles'
'SL'	'Sierra Leone'	'Sierra Leone'
'SG'	'Singapore'	'Singapour'
'SK'	'Slovak Republic'	'Slovaquie'
'SI'	'Slovenia'	'Slovénie'
'SB'	'Solomon Islands'	'Salomon, Îles'
'SO'	'Somalia'	'Somalie'
'ZA'	'South Africa'	'Afrique Du Sud'
'GS' 'South Georgia and the South Sandwich Islands' 'Géorgie du Sud et les Îles Sandwich du Sud'
'ES'	'Spain'	'Espagne'
'LK'	'Sri Lanka'	'Sri Lanka'
'SH'	'St Helena'	'Sainte-hélène'
'PM'	'St Pierre and Miquelon'	'Saint-pierre-et-miquelon'
'SD'	'Sudan'	'Soudan'
'SR'	'Suriname'	'Suriname'
'SJ'	'Svalbard and Jan Mayen Islands'	'Svalbard et Île Jan Mayen'
'SZ'	'Swaziland'	'Swaziland'
'SE'	'Sweden'	'Suède'
'CH'	'Switzerland'	'Suisse'
'SY'	'Syrian Arab Republic'	'Syrienne, République Arabe'
'TW'	'Taiwan'	'Taïwan, Province De Chine'
'TJ'	'Tajikistan'	'Tadjikistan'
'TZ'	'Tanzania'	'Tanzanie, République-unie de'
'TH'	'Thailand'	'Thaïlande'
'TG'	'Togo'	'Togo'
'TK'	'Tokelau'	'Tokelau'
'TO'	'Tonga'	'Tonga'
'TT'	'Trinidad and Tobago'	'Trinité-et-tobago'
'TN'	'Tunisia'	'Tunisie'
'TR'	'Turkey'	'Turquie'
'TM'	'Turkmenistan'	'Turkménistan'
'TC'	'Turks and Caicos Islands'	'Turks et Caïques, Îles'
'TV'	'Tuvalu'	'Tuvalu'
'UM'	'US Minor Outlying Islands'	'Îles Mineures Éloignées des États-unis'
'UG'	'Uganda'	'Ouganda'
'UA'	'Ukraine'	'Ukraine'
'AE'	'United Arab Emirates'	'Émirats Arabes Unis'
'GB'	'United Kingdom'	'Royaume-Uni'
'US'	'United States'	'États-unis'
'UY'	'Uruguay'	'Uruguay'
'UZ'	'Uzbekistan'	'Ouzbékistan'
'VU'	'Vanuatu'	'Vanuatu'
'VE'	'Venezuela'	'Venezuela'
'VN'	'Vietnam'	'Viet Nam'
'VG'	'Virgin Islands (British)'	'Îles Vierges Britanniques'
'VI'	'Virgin Islands (USA)'	'Îles Vierges des États-unis'
'WF'	'Wallis and Futuna Islands'	'Wallis et Futuna'
'EH'	'Western Sahara'	'Sahara Occidental'
'WS'	'Western Samoa'	'Samoa'
'YE'	'Yemen'	'Yémen'
'CS'	'Serbia and Montenegro'	'Serbie-et-Monténégro'
'ZM'	'Zambia'	'Zambie'
'ZW'	'Zimbabwe'	'Zimbabwe'


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux