http://snippets.dzone.com/posts Sun, 18 May 2008 14:02:06 GMT DZone Snippets: country code http://snippets.dzone.com/posts/show/5255 // Split Apache logs according to GeoIP country <br /> <br /><code> <br />#!/usr/bin/perl <br /> <br /># $Id$ <br /> <br /># Split Apache logs according to GeoIP country <br /> <br />use strict; <br />use warnings; <br /> <br />## no critic (ValuesAndExpressions::RequireInterpolationOfMetachars) <br />our ($VERSION) = '$Revision$' =~ m{ \$Revision: \s+ (\S+) }xms; <br />## use critic <br /> <br />use Geo::IP; <br /> <br />my $gi = Geo::IP->open('/usr/local/share/GeoIP/GeoIPCity.dat', GEOIP_STANDARD); <br /> <br />my @logs = @ARGV; <br /> <br />my %record_for; <br /> <br />foreach my $log (@logs) { <br /> die "Can't read $log\n" if !-r $log; <br /> <br /> my %fh_for; <br /> my $num_lines_parsed = 0; <br /> <br /> my $log_fh; <br /> if ($log =~ m/ \.gz \z /xms) { <br /> open $log_fh, "gzip -cd $log |" or die "Can't open gzip pipe\n"; <br /> } <br /> else { <br /> open $log_fh, '<', $log or die "Can't open $log\n"; <br /> } <br /> <br /> my $log_base = $log; <br /> $log_base =~ s/ \.gz \z //xms; <br /> <br /> while (my $line = <$log_fh>) { <br /> $num_lines_parsed++; <br /> if (!($num_lines_parsed % 1000)) { <br /> print STDERR "Parsed $num_lines_parsed lines of $log\n"; <br /> } <br /> <br /> my ($host) = $line =~ m/ \A (\S+) \s /xms; <br /> <br /> if (!exists $record_for{$host}) { <br /> my $record = $gi->record_by_name($host); <br /> $record_for{$host} = $record || 0; <br /> } <br /> <br /> my $country = 'unknown'; <br /> if (exists $record_for{$host} && $record_for{$host}) { <br /> $country = lc($record_for{$host}->country_name()); <br /> $country =~ s/\W+/_/gxms; <br /> } <br /> <br /> if (!exists $fh_for{$country}) { <br /> open $fh_for{$country}, '>', "$log_base.$country.out" <br /> or die "Can't write to $log_base.$country.out\n"; <br /> } <br /> <br /> print {$fh_for{$country}} $line; <br /> } <br /> <br /> foreach my $fh (values %fh_for) { <br /> close $fh; <br /> } <br /> <br /> close $log_fh; <br />} <br /></code> Wed, 19 Mar 2008 15:02:26 GMT http://snippets.dzone.com/posts/show/5255 iansealy (Ian Sealy) http://snippets.dzone.com/posts/show/4568 List of countries in Catalan, without formatting. <br /> <br /><code>Afganistan <br />Albània <br />Alemanya <br />Andorra <br />Angola <br />Antigua i Barbuda <br />Antilles <br />Antilles Holandeses <br />Aràbia Saudita <br />Svalbard <br />Algèria <br />Argentina <br />Armènia <br />Aruba <br />Austràlia <br />Àustria <br />Azerbaidjan <br />Bahames <br />Bahrein (illes) <br />Bangla Desh <br />Barbados <br />Bèlgica <br />Belize <br />Bermudes <br />Bhutan <br />Bielorússia <br />Bolívia <br />Bòsnia i Herzegovina <br />Botswana <br />Brasil <br />Brunei <br />Bulgària <br />Burkina Faso <br />Burundi <br />Cap Verd <br />Cambodja <br />Camerun <br />Canadà <br />Txad <br />Xile <br />Xina <br />Xipre <br />Ciutat del Vaticà <br />Colòmbia <br />Comores <br />Congo <br />Corea del Nord <br />Corea del Sud <br />Costa d'Ivori <br />Costa Rica <br />Croàcia <br />Cuba <br />Benín <br />Dinamarca <br />Djibouti <br />Dominica <br />Equador <br />Egipte <br />El Salvador <br />Emirats Àrabs Units <br />Eritrea <br />Eslovàquia <br />Eslovènia <br />Espanya <br />Estats Units d'Amèrica <br />Estònia <br />Etiòpia <br />Federació Russa <br />Federació Malaia <br />Fiji <br />Filipines <br />Finlàndia <br />França <br />Gabon <br />Gàmbia <br />Geòrgia <br />Ghana <br />Gibraltar <br />Granada <br />Grècia <br />Groenlàndia <br />Guadalupe <br />Guatemala <br />Guinea <br />Guinea Bissau <br />Guinea Equatorial <br />Guaiana <br />Guaiana Francesa <br />Haití <br />Hondures <br />Hong Kong <br />Hongria <br />Índia <br />Indonèsia <br />Iraq <br />Iran <br />Irlanda <br />Man (illa de) <br />Islàndia <br />Anglonormandes (illes) <br />Caiman Islands <br />Cook (illes) <br />Fèroe (illes) <br />Malvines (illes) <br />Mariannes (illes) <br />Marshall (illes) <br />Salomó (illes) <br />Turks i Caicos (illes) <br />Verges Britàniques (illes) <br />Wallis i Futuna (illes) <br />Israel <br />Itàlia <br />Jamaica <br />Japó <br />Jordània <br />Kazakhstan <br />Kenya <br />Kirguizistan <br />Kiribati <br />Kuwait <br />Laos <br />Lesotho <br />Letònia <br />Líban <br />Libèria <br />Líbia <br />Liechtenstein <br />Lituània <br />Luxemburg <br />Macau <br />Macedònia <br />Madagascar <br />Malàisia <br />Malawi <br />Maldives <br />Mali <br />Malta <br />Marroc <br />Martinica <br />Maurici <br />Mauritània <br />Mayotte <br />Mèxic <br />Micronèsia <br />Mònaco <br />Mongòlia <br />Montserrat <br />Moçambic <br />Myanmar <br />Namíbia <br />Nauru <br />Nepal <br />Nicaragua <br />Níger <br />Nigèria <br />Noruega <br />Nova Caledònia <br />Nova Zelanda <br />Oceania Americana <br />Oceania Australiana <br />Oceania Neozelandesa <br />Oman <br />Països Baixos <br />Pakistan <br />Palau (illes) <br />Palestina <br />Panamà <br />Papua Nova Guinea <br />Paraguai <br />Perú <br />Pitcairn <br />Polinèsia Francesa <br />Polònia <br />Portugal <br />Puerto Rico <br />Qatar <br />Regne Unit <br />República Txeca <br />República Dominicana <br />República Centreafricana <br />República Democràtica del Congo <br />Reunió (illa de la) <br />Rwanda <br />Romania <br />Samoa <br />Saint Christopher i Nevis <br />Saint-Pierre-et-Miquelon <br />Saint Vincent i les Grenadines <br />Saint Helena <br />Saint Lucia <br />São Tomé i Príncipe <br />Senegal <br />Seychelles <br />Sierra Leone <br />Singapur <br />Síria <br />Somàlia <br />Sud-àfrica <br />Sri Lanka <br />Sudan <br />Suècia <br />Suïssa <br />Surinam <br />Swazilàndia <br />Tailàndia <br />Taiwan <br />Tadjikistan <br />Tanzània <br />Timor Oriental <br />Togo <br />Tonga <br />Trinitat i Tobago <br />Tunísia <br />Turkmenistan <br />Turquia <br />Tuvalu <br />Uganda <br />Ucraïna <br />Uruguai <br />Uzbekistan <br />Vanuatu <br />Veneçuela <br />Vietnam <br />Iemen <br />Iugoslàvia <br />Zàmbia <br />Zimbabwe <br /></code> Mon, 24 Sep 2007 16:29:08 GMT http://snippets.dzone.com/posts/show/4568 laura_vidal (laura) http://snippets.dzone.com/posts/show/4567 List of countries in Spanish, without formatting <br /> <br /><code> <br />Afganistán <br />Albania <br />Alemania <br />Andorra <br />Angola <br />Antigua y Barbuda <br />Antillas <br />Antillas Holandesas <br />Arabia Saudita <br />Archipiélago Svalbard <br />Argelia <br />Argentina <br />Armenia <br />Aruba <br />Australia <br />Austria <br />Azerbaiyán <br />Bahamas <br />Bahrein (islas) <br />Bangladesh <br />Barbados <br />Bélgica <br />Belice <br />Bermudas <br />Bhután <br />Bielorrusia <br />Bolivia <br />Bosnia y Herzegovina <br />Botswana <br />Brasil <br />Brunei <br />Bulgaria <br />Burkina Faso <br />Burundi <br />Cabo Verde <br />Camboya <br />Camerún <br />Canadá <br />Chad <br />Chile <br />China <br />Chipre <br />Ciudad del Vaticano <br />Colombia <br />Comores <br />Congo <br />Corea del Norte <br />Corea del Sur <br />Costa de Marfil <br />Costa Rica <br />Croacia <br />Cuba <br />Benín <br />Dinamarca <br />Djibouti <br />Dominica <br />Ecuador <br />Egipto <br />El Salvador <br />Emiratos Árabes Unidos <br />Eritrea <br />Eslovaquia <br />Eslovenia <br />España <br />Estados Unidos de América <br />Estonia <br />Etiopía <br />Federación Rusa <br />Federación Malaya <br />Fiji <br />Filipinas <br />Finlandia <br />Francia <br />Gabón <br />Gambia <br />Georgia <br />Ghana <br />Gibraltar <br />Granada <br />Grecia <br />Groenlandia <br />Guadalupe <br />Guatemala <br />Guinea <br />Guinea-Bissau <br />Guinea Ecuatorial <br />Guyana <br />Guyana Francesa <br />Haití <br />Honduras <br />Hong Kong <br />Hungría <br />India <br />Indonesia <br />Iraq <br />Irán <br />Irlanda <br />Isla de Man <br />Islandia <br />Islas Anglonormandas <br />Islas Cayman <br />Islas Cook <br />Islas Feroe <br />Islas Malvinas <br />Islas Marianas del Norte <br />Islas Marshall <br />Islas Salomón <br />Islas Turks y Caicos <br />Islas Vírgenes Británicas <br />Islas Wallis y Fortuna <br />Israel <br />Italia <br />Jamaica <br />Japón <br />Jordania <br />Kazajstán <br />Kenya <br />Kirguizistán <br />Kiribati <br />Kuwait <br />Laos <br />Lesotho <br />Letonia <br />Líbano <br />Liberia <br />Libia <br />Liechtenstein <br />Lituania <br />Luxemburgo <br />Macao <br />Macedonia <br />Madagascar <br />Malasia <br />Malawi <br />Maldivas <br />Malí <br />Malta <br />Marruecos <br />Martinica <br />Mauricio <br />Mauritania <br />Mayotte <br />México <br />Micronesia <br />Mónaco <br />Mongolia <br />Montserrat <br />Mozambique <br />Myanmar <br />Namibia <br />Nauru <br />Nepal <br />Nicaragua <br />Níger <br />Nigeria <br />Noruega <br />Nueva Caledonia <br />Nueva Zelanda <br />Oceanía Americana <br />Oceanía Australiana <br />Oceanía Neozelandesa <br />Omán <br />Países Bajos <br />Pakistán <br />Palau <br />Palestina <br />Panamá <br />Papua Nueva Guinea <br />Paraguay <br />Perú <br />Pitcairn <br />Polinesia Francesa <br />Polonia <br />Portugal <br />Puerto Rico <br />Qatar <br />Reino Unido <br />República Checa <br />República Dominicana <br />República Centroafricana <br />República Democrática del Congo <br />Reunion <br />Ruanda <br />Rumania <br />Samoa <br />Saint Christopher y Nevis <br />San Pedro y Miquelon <br />San Vicente <br />Santa Helena <br />Santa Lucía <br />Santo Tomé y Príncipe <br />Senegal <br />Seychelles <br />Sierra Leona <br />Singapur <br />Siria <br />Somalia <br />Sudáfrica <br />Sri Lanka <br />Sudán <br />Suecia <br />Suiza <br />Surinam <br />Swazilandia <br />Tailandia <br />Taiwan <br />Tayikistán <br />Tanzania <br />Timor Oriental <br />Togo <br />Tonga <br />Trinidad y Tobago <br />Túnez <br />Turkmenistán <br />Turquía <br />Tuvalu <br />Uganda <br />Ucrania <br />Uruguay <br />Uzbekistán <br />Vanuatu <br />Venezuela <br />Vietnam <br />Yemen <br />Yugoslavia <br />Zambia <br />Zimbabwe <br /></code> Mon, 24 Sep 2007 16:28:23 GMT http://snippets.dzone.com/posts/show/4567 laura_vidal (laura) http://snippets.dzone.com/posts/show/4566 List of countries without formatting. <br /> <br /><code>Afghanistan <br />Albania <br />Germany <br />Andorra <br />Angola <br />Antigua and Barbuda <br />Antilles <br />Netherlands Antilles <br />Saudi Arabia <br />Svalbard <br />Algeria <br />Argentina <br />Armenia <br />Aruba <br />Australia <br />Austria <br />Azerbaijan <br />Bahamas <br />Bahrain <br />Bangladesh <br />Barbados <br />Belgium <br />Belize <br />Bermuda <br />Bhutan <br />Belarus <br />Bolivia <br />Bosnia and Herzegovina <br />Botswana <br />Brazil <br />Brunei <br />Bulgaria <br />Burkina-Faso <br />Burundi <br />Cape Verde <br />Cambodia <br />Cameroon <br />Canada <br />Chad <br />Chile <br />China <br />Cyprus <br />Vatican City <br />Colombia <br />Comoros <br />Congo <br />North Korea <br />South Korea <br />Côte d'Ivoire <br />Costa Rica <br />Croatia <br />Cuba <br />Benin <br />Denmark <br />Djibouti <br />Dominica <br />Ecuador <br />Egypt <br />El Salvador <br />United Arab Emirates <br />Eritrea <br />Slovakia <br />Slovenia <br />Spain <br />United States of America <br />Estonia <br />Ethiopia <br />Russian Federation <br />Malay States <br />Fiji <br />Republic of the Philippines <br />Finland <br />France <br />Gabon <br />Gambia <br />Georgia <br />Ghana <br />Gibraltar <br />Grenada <br />Greece <br />Greenland <br />Guadeloupe <br />Guatemala <br />Guinea <br />Guinea-Bissau <br />Equatorial Guinea <br />Guiana <br />French Guiana <br />Haiti <br />Honduras <br />Hong Kong <br />Hungary <br />India <br />Indonesia <br />Iraq <br />Iran <br />Ireland <br />Isle of Man <br />Iceland <br />Channel Islands <br />Cayman Islands <br />Cook Islands <br />Faeroes <br />Falkland Islands <br />Northern Mariana Islands <br />Marshall Islands <br />Solomon Islands <br />Turks and Caicos Islands <br />British Virgin Islands <br />Wallis and Futuna Islands <br />Israel <br />Italy <br />Jamaica <br />Japan <br />Jordan <br />Kazakhstan <br />Kenya <br />Kyrgyzstan <br />Kiribati <br />Kuwait <br />Laos <br />Lesotho <br />Latvia <br />Lebanon <br />Liberia <br />Libya <br />Liechtenstein <br />Lithuania <br />Luxemburg <br />Macao <br />Macedonia <br />Madagascar <br />Malaysia <br />Malawi <br />Maldives <br />Mali <br />Malta <br />Morocco <br />Martinique <br />Mauritius <br />Mauritania <br />Mayotte <br />Mexico <br />Micronesia <br />Monaco <br />Mongolia <br />Montserrat <br />Mozambique <br />Myanmar <br />Namibia <br />Nauru <br />Nepal <br />Nicaragua <br />Niger <br />Nigeria <br />Norway <br />New Caledonia <br />New Zealand <br />Polynesia <br />Micronesia <br />Melanesia <br />Oman <br />Netherlands <br />Pakistan <br />Palau Islands <br />Palestine <br />Panama <br />Papua New Guinea <br />Paraguay <br />Peru <br />Pitcairn Island <br />French Polynesia <br />Poland <br />Portugal <br />Puerto Rico <br />Qatar <br />United Kingdom <br />Czech Republic <br />Dominican Republic <br />Central African Republic <br />Democratic Republic of the Congo <br />Réunion <br />Rwanda <br />Romania <br />Samoa <br />Saint Christopher-Nevis <br />Saint Pierre and Miquelon <br />Saint Vincent and the Grenadines <br />Saint Helena <br />Saint Lucia <br />São Tomé e Principe <br />Senegal <br />Seychelles <br />Sierra Leone <br />Singapore <br />Syria <br />Somalia <br />South Africa <br />Sri Lanka <br />Sudan <br />Sweden <br />Switzerland <br />Surinam <br />Swaziland <br />Thailand <br />Taiwan <br />Tajikistan <br />Tanzania <br />East Timor <br />Togo <br />Tonga <br />Trinidad and Tobago <br />Tunisia <br />Turkmenistan <br />Turkey <br />Tuvalu <br />Uganda <br />Ukraine <br />Uruguay <br />Uzbekistan <br />Vanuatu <br />Venezuela <br />Vietnam <br />Yemen Republic <br />Yugoslavia <br />Zambia <br />Zimbabwe <br /></code> Mon, 24 Sep 2007 16:24:12 GMT http://snippets.dzone.com/posts/show/4566 laura_vidal (laura) http://snippets.dzone.com/posts/show/1727 I use rails. It's great. It automatically creates a select list of countries. It doesn't, however, know about the 2 and 3 character country code. <br /> <br />So, I need a country table, with countries. <br /> <br />This migration creates and populates a 'countries' table. <br /> <br />You'll have to <br /> <br /><code> <br /> ./script/generate model Country <br /></code> <br /> <br />before you run it. <br /> <br /> <br /> <br /><code> <br />class CreateCountryTable < ActiveRecord::Migration <br /> def self.up <br /> ## Create country table <br /> create_table :countries do |t| <br /> t.column :iso, :string, :size => 2 <br /> t.column :name, :string, :size => 80 <br /> t.column :printable_name, :string, :size => 80 <br /> t.column :iso3, :string, :size => 3 <br /> t.column :numcode, :integer <br /> end <br /> <br /> Country.reset_column_information <br /> Country.create(:iso => 'AF', :name => 'AFGHANISTAN', :printable_name => 'Afghanistan', :iso3 => 'AFG', :numcode => '004') <br /> Country.create(:iso => 'AL', :name => 'ALBANIA', :printable_name => 'Albania', :iso3 => 'ALB', :numcode => '008') <br /> Country.create(:iso => 'DZ', :name => 'ALGERIA', :printable_name => 'Algeria', :iso3 => 'DZA', :numcode => '012') <br /> Country.create(:iso => 'AS', :name => 'AMERICAN SAMOA', :printable_name => 'American Samoa', :iso3 => 'ASM', :numcode => '016') <br /> Country.create(:iso => 'AD', :name => 'ANDORRA', :printable_name => 'Andorra', :iso3 => 'AND', :numcode => '020') <br /> Country.create(:iso => 'AO', :name => 'ANGOLA', :printable_name => 'Angola', :iso3 => 'AGO', :numcode => '024') <br /> Country.create(:iso => 'AI', :name => 'ANGUILLA', :printable_name => 'Anguilla', :iso3 => 'AIA', :numcode => '660') <br /> Country.create(:iso => 'AG', :name => 'ANTIGUA AND BARBUDA', :printable_name => 'Antigua and Barbuda', :iso3 => 'ATG', :numcode => '028') <br /> Country.create(:iso => 'AR', :name => 'ARGENTINA', :printable_name => 'Argentina', :iso3 => 'ARG', :numcode => '032') <br /> Country.create(:iso => 'AM', :name => 'ARMENIA', :printable_name => 'Armenia', :iso3 => 'ARM', :numcode => '051') <br /> Country.create(:iso => 'AW', :name => 'ARUBA', :printable_name => 'Aruba', :iso3 => 'ABW', :numcode => '533') <br /> Country.create(:iso => 'AU', :name => 'AUSTRALIA', :printable_name => 'Australia', :iso3 => 'AUS', :numcode => '036') <br /> Country.create(:iso => 'AT', :name => 'AUSTRIA', :printable_name => 'Austria', :iso3 => 'AUT', :numcode => '040') <br /> Country.create(:iso => 'AZ', :name => 'AZERBAIJAN', :printable_name => 'Azerbaijan', :iso3 => 'AZE', :numcode => '031') <br /> Country.create(:iso => 'BS', :name => 'BAHAMAS', :printable_name => 'Bahamas', :iso3 => 'BHS', :numcode => '044') <br /> Country.create(:iso => 'BH', :name => 'BAHRAIN', :printable_name => 'Bahrain', :iso3 => 'BHR', :numcode => '048') <br /> Country.create(:iso => 'BD', :name => 'BANGLADESH', :printable_name => 'Bangladesh', :iso3 => 'BGD', :numcode => '050') <br /> Country.create(:iso => 'BB', :name => 'BARBADOS', :printable_name => 'Barbados', :iso3 => 'BRB', :numcode => '052') <br /> Country.create(:iso => 'BY', :name => 'BELARUS', :printable_name => 'Belarus', :iso3 => 'BLR', :numcode => '112') <br /> Country.create(:iso => 'BE', :name => 'BELGIUM', :printable_name => 'Belgium', :iso3 => 'BEL', :numcode => '056') <br /> Country.create(:iso => 'BZ', :name => 'BELIZE', :printable_name => 'Belize', :iso3 => 'BLZ', :numcode => '084') <br /> Country.create(:iso => 'BJ', :name => 'BENIN', :printable_name => 'Benin', :iso3 => 'BEN', :numcode => '204') <br /> Country.create(:iso => 'BM', :name => 'BERMUDA', :printable_name => 'Bermuda', :iso3 => 'BMU', :numcode => '060') <br /> Country.create(:iso => 'BT', :name => 'BHUTAN', :printable_name => 'Bhutan', :iso3 => 'BTN', :numcode => '064') <br /> Country.create(:iso => 'BO', :name => 'BOLIVIA', :printable_name => 'Bolivia', :iso3 => 'BOL', :numcode => '068') <br /> Country.create(:iso => 'BA', :name => 'BOSNIA AND HERZEGOVINA', :printable_name => 'Bosnia and Herzegovina', :iso3 => 'BIH', :numcode => '070') <br /> Country.create(:iso => 'BW', :name => 'BOTSWANA', :printable_name => 'Botswana', :iso3 => 'BWA', :numcode => '072') <br /> Country.create(:iso => 'BR', :name => 'BRAZIL', :printable_name => 'Brazil', :iso3 => 'BRA', :numcode => '076') <br /> Country.create(:iso => 'BN', :name => 'BRUNEI DARUSSALAM', :printable_name => 'Brunei Darussalam', :iso3 => 'BRN', :numcode => '096') <br /> Country.create(:iso => 'BG', :name => 'BULGARIA', :printable_name => 'Bulgaria', :iso3 => 'BGR', :numcode => '100') <br /> Country.create(:iso => 'BF', :name => 'BURKINA FASO', :printable_name => 'Burkina Faso', :iso3 => 'BFA', :numcode => '854') <br /> Country.create(:iso => 'BI', :name => 'BURUNDI', :printable_name => 'Burundi', :iso3 => 'BDI', :numcode => '108') <br /> Country.create(:iso => 'KH', :name => 'CAMBODIA', :printable_name => 'Cambodia', :iso3 => 'KHM', :numcode => '116') <br /> Country.create(:iso => 'CM', :name => 'CAMEROON', :printable_name => 'Cameroon', :iso3 => 'CMR', :numcode => '120') <br /> Country.create(:iso => 'CA', :name => 'CANADA', :printable_name => 'Canada', :iso3 => 'CAN', :numcode => '124') <br /> Country.create(:iso => 'CV', :name => 'CAPE VERDE', :printable_name => 'Cape Verde', :iso3 => 'CPV', :numcode => '132') <br /> Country.create(:iso => 'KY', :name => 'CAYMAN ISLANDS', :printable_name => 'Cayman Islands', :iso3 => 'CYM', :numcode => '136') <br /> Country.create(:iso => 'CF', :name => 'CENTRAL AFRICAN REPUBLIC', :printable_name => 'Central African Republic', :iso3 => 'CAF', :numcode => '140') <br /> Country.create(:iso => 'TD', :name => 'CHAD', :printable_name => 'Chad', :iso3 => 'TCD', :numcode => '148') <br /> Country.create(:iso => 'CL', :name => 'CHILE', :printable_name => 'Chile', :iso3 => 'CHL', :numcode => '152') <br /> Country.create(:iso => 'CN', :name => 'CHINA', :printable_name => 'China', :iso3 => 'CHN', :numcode => '156') <br /> Country.create(:iso => 'CO', :name => 'COLOMBIA', :printable_name => 'Colombia', :iso3 => 'COL', :numcode => '170') <br /> Country.create(:iso => 'KM', :name => 'COMOROS', :printable_name => 'Comoros', :iso3 => 'COM', :numcode => '174') <br /> Country.create(:iso => 'CG', :name => 'CONGO', :printable_name => 'Congo', :iso3 => 'COG', :numcode => '178') <br /> Country.create(:iso => 'CD', :name => 'CONGO, THE DEMOCRATIC REPUBLIC OF THE', :printable_name => 'Congo, the Democratic Republic of the', :iso3 => 'COD', :numcode => '180') <br /> Country.create(:iso => 'CK', :name => 'COOK ISLANDS', :printable_name => 'Cook Islands', :iso3 => 'COK', :numcode => '184') <br /> Country.create(:iso => 'CR', :name => 'COSTA RICA', :printable_name => 'Costa Rica', :iso3 => 'CRI', :numcode => '188') <br /> Country.create(:iso => 'CI', :name => 'COTE D\'IVOIRE', :printable_name => 'Cote D\'Ivoire', :iso3 => 'CIV', :numcode => '384') <br /> Country.create(:iso => 'HR', :name => 'CROATIA', :printable_name => 'Croatia', :iso3 => 'HRV', :numcode => '191') <br /> Country.create(:iso => 'CU', :name => 'CUBA', :printable_name => 'Cuba', :iso3 => 'CUB', :numcode => '192') <br /> Country.create(:iso => 'CY', :name => 'CYPRUS', :printable_name => 'Cyprus', :iso3 => 'CYP', :numcode => '196') <br /> Country.create(:iso => 'CZ', :name => 'CZECH REPUBLIC', :printable_name => 'Czech Republic', :iso3 => 'CZE', :numcode => '203') <br /> Country.create(:iso => 'DK', :name => 'DENMARK', :printable_name => 'Denmark', :iso3 => 'DNK', :numcode => '208') <br /> Country.create(:iso => 'DJ', :name => 'DJIBOUTI', :printable_name => 'Djibouti', :iso3 => 'DJI', :numcode => '262') <br /> Country.create(:iso => 'DM', :name => 'DOMINICA', :printable_name => 'Dominica', :iso3 => 'DMA', :numcode => '212') <br /> Country.create(:iso => 'DO', :name => 'DOMINICAN REPUBLIC', :printable_name => 'Dominican Republic', :iso3 => 'DOM', :numcode => '214') <br /> Country.create(:iso => 'EC', :name => 'ECUADOR', :printable_name => 'Ecuador', :iso3 => 'ECU', :numcode => '218') <br /> Country.create(:iso => 'EG', :name => 'EGYPT', :printable_name => 'Egypt', :iso3 => 'EGY', :numcode => '818') <br /> Country.create(:iso => 'SV', :name => 'EL SALVADOR', :printable_name => 'El Salvador', :iso3 => 'SLV', :numcode => '222') <br /> Country.create(:iso => 'GQ', :name => 'EQUATORIAL GUINEA', :printable_name => 'Equatorial Guinea', :iso3 => 'GNQ', :numcode => '226') <br /> Country.create(:iso => 'ER', :name => 'ERITREA', :printable_name => 'Eritrea', :iso3 => 'ERI', :numcode => '232') <br /> Country.create(:iso => 'EE', :name => 'ESTONIA', :printable_name => 'Estonia', :iso3 => 'EST', :numcode => '233') <br /> Country.create(:iso => 'ET', :name => 'ETHIOPIA', :printable_name => 'Ethiopia', :iso3 => 'ETH', :numcode => '231') <br /> Country.create(:iso => 'FK', :name => 'FALKLAND ISLANDS (MALVINAS)', :printable_name => 'Falkland Islands (Malvinas)', :iso3 => 'FLK', :numcode => '238') <br /> Country.create(:iso => 'FO', :name => 'FAROE ISLANDS', :printable_name => 'Faroe Islands', :iso3 => 'FRO', :numcode => '234') <br /> Country.create(:iso => 'FJ', :name => 'FIJI', :printable_name => 'Fiji', :iso3 => 'FJI', :numcode => '242') <br /> Country.create(:iso => 'FI', :name => 'FINLAND', :printable_name => 'Finland', :iso3 => 'FIN', :numcode => '246') <br /> Country.create(:iso => 'FR', :name => 'FRANCE', :printable_name => 'France', :iso3 => 'FRA', :numcode => '250') <br /> Country.create(:iso => 'GF', :name => 'FRENCH GUIANA', :printable_name => 'French Guiana', :iso3 => 'GUF', :numcode => '254') <br /> Country.create(:iso => 'PF', :name => 'FRENCH POLYNESIA', :printable_name => 'French Polynesia', :iso3 => 'PYF', :numcode => '258') <br /> Country.create(:iso => 'GA', :name => 'GABON', :printable_name => 'Gabon', :iso3 => 'GAB', :numcode => '266') <br /> Country.create(:iso => 'GM', :name => 'GAMBIA', :printable_name => 'Gambia', :iso3 => 'GMB', :numcode => '270') <br /> Country.create(:iso => 'GE', :name => 'GEORGIA', :printable_name => 'Georgia', :iso3 => 'GEO', :numcode => '268') <br /> Country.create(:iso => 'DE', :name => 'GERMANY', :printable_name => 'Germany', :iso3 => 'DEU', :numcode => '276') <br /> Country.create(:iso => 'GH', :name => 'GHANA', :printable_name => 'Ghana', :iso3 => 'GHA', :numcode => '288') <br /> Country.create(:iso => 'GI', :name => 'GIBRALTAR', :printable_name => 'Gibraltar', :iso3 => 'GIB', :numcode => '292') <br /> Country.create(:iso => 'GR', :name => 'GREECE', :printable_name => 'Greece', :iso3 => 'GRC', :numcode => '300') <br /> Country.create(:iso => 'GL', :name => 'GREENLAND', :printable_name => 'Greenland', :iso3 => 'GRL', :numcode => '304') <br /> Country.create(:iso => 'GD', :name => 'GRENADA', :printable_name => 'Grenada', :iso3 => 'GRD', :numcode => '308') <br /> Country.create(:iso => 'GP', :name => 'GUADELOUPE', :printable_name => 'Guadeloupe', :iso3 => 'GLP', :numcode => '312') <br /> Country.create(:iso => 'GU', :name => 'GUAM', :printable_name => 'Guam', :iso3 => 'GUM', :numcode => '316') <br /> Country.create(:iso => 'GT', :name => 'GUATEMALA', :printable_name => 'Guatemala', :iso3 => 'GTM', :numcode => '320') <br /> Country.create(:iso => 'GN', :name => 'GUINEA', :printable_name => 'Guinea', :iso3 => 'GIN', :numcode => '324') <br /> Country.create(:iso => 'GW', :name => 'GUINEA-BISSAU', :printable_name => 'Guinea-Bissau', :iso3 => 'GNB', :numcode => '624') <br /> Country.create(:iso => 'GY', :name => 'GUYANA', :printable_name => 'Guyana', :iso3 => 'GUY', :numcode => '328') <br /> Country.create(:iso => 'HT', :name => 'HAITI', :printable_name => 'Haiti', :iso3 => 'HTI', :numcode => '332') <br /> Country.create(:iso => 'VA', :name => 'HOLY SEE (VATICAN CITY STATE)', :printable_name => 'Holy See (Vatican City State)', :iso3 => 'VAT', :numcode => '336') <br /> Country.create(:iso => 'HN', :name => 'HONDURAS', :printable_name => 'Honduras', :iso3 => 'HND', :numcode => '340') <br /> Country.create(:iso => 'HK', :name => 'HONG KONG', :printable_name => 'Hong Kong', :iso3 => 'HKG', :numcode => '344') <br /> Country.create(:iso => 'HU', :name => 'HUNGARY', :printable_name => 'Hungary', :iso3 => 'HUN', :numcode => '348') <br /> Country.create(:iso => 'IS', :name => 'ICELAND', :printable_name => 'Iceland', :iso3 => 'ISL', :numcode => '352') <br /> Country.create(:iso => 'IN', :name => 'INDIA', :printable_name => 'India', :iso3 => 'IND', :numcode => '356') <br /> Country.create(:iso => 'ID', :name => 'INDONESIA', :printable_name => 'Indonesia', :iso3 => 'IDN', :numcode => '360') <br /> Country.create(:iso => 'IR', :name => 'IRAN, ISLAMIC REPUBLIC OF', :printable_name => 'Iran, Islamic Republic of', :iso3 => 'IRN', :numcode => '364') <br /> Country.create(:iso => 'IQ', :name => 'IRAQ', :printable_name => 'Iraq', :iso3 => 'IRQ', :numcode => '368') <br /> Country.create(:iso => 'IE', :name => 'IRELAND', :printable_name => 'Ireland', :iso3 => 'IRL', :numcode => '372') <br /> Country.create(:iso => 'IL', :name => 'ISRAEL', :printable_name => 'Israel', :iso3 => 'ISR', :numcode => '376') <br /> Country.create(:iso => 'IT', :name => 'ITALY', :printable_name => 'Italy', :iso3 => 'ITA', :numcode => '380') <br /> Country.create(:iso => 'JM', :name => 'JAMAICA', :printable_name => 'Jamaica', :iso3 => 'JAM', :numcode => '388') <br /> Country.create(:iso => 'JP', :name => 'JAPAN', :printable_name => 'Japan', :iso3 => 'JPN', :numcode => '392') <br /> Country.create(:iso => 'JO', :name => 'JORDAN', :printable_name => 'Jordan', :iso3 => 'JOR', :numcode => '400') <br /> Country.create(:iso => 'KZ', :name => 'KAZAKHSTAN', :printable_name => 'Kazakhstan', :iso3 => 'KAZ', :numcode => '398') <br /> Country.create(:iso => 'KE', :name => 'KENYA', :printable_name => 'Kenya', :iso3 => 'KEN', :numcode => '404') <br /> Country.create(:iso => 'KI', :name => 'KIRIBATI', :printable_name => 'Kiribati', :iso3 => 'KIR', :numcode => '296') <br /> Country.create(:iso => 'KP', :name => 'KOREA, DEMOCRATIC PEOPLE\'S REPUBLIC OF', :printable_name => 'Korea, Democratic People\'s Republic of', :iso3 => 'PRK', :numcode => '408') <br /> Country.create(:iso => 'KR', :name => 'KOREA, REPUBLIC OF', :printable_name => 'Korea, Republic of', :iso3 => 'KOR', :numcode => '410') <br /> Country.create(:iso => 'KW', :name => 'KUWAIT', :printable_name => 'Kuwait', :iso3 => 'KWT', :numcode => '414') <br /> Country.create(:iso => 'KG', :name => 'KYRGYZSTAN', :printable_name => 'Kyrgyzstan', :iso3 => 'KGZ', :numcode => '417') <br /> Country.create(:iso => 'LA', :name => 'LAO PEOPLE\'S DEMOCRATIC REPUBLIC', :printable_name => 'Lao People\'s Democratic Republic', :iso3 => 'LAO', :numcode => '418') <br /> Country.create(:iso => 'LV', :name => 'LATVIA', :printable_name => 'Latvia', :iso3 => 'LVA', :numcode => '428') <br /> Country.create(:iso => 'LB', :name => 'LEBANON', :printable_name => 'Lebanon', :iso3 => 'LBN', :numcode => '422') <br /> Country.create(:iso => 'LS', :name => 'LESOTHO', :printable_name => 'Lesotho', :iso3 => 'LSO', :numcode => '426') <br /> Country.create(:iso => 'LR', :name => 'LIBERIA', :printable_name => 'Liberia', :iso3 => 'LBR', :numcode => '430') <br /> Country.create(:iso => 'LY', :name => 'LIBYAN ARAB JAMAHIRIYA', :printable_name => 'Libyan Arab Jamahiriya', :iso3 => 'LBY', :numcode => '434') <br /> Country.create(:iso => 'LI', :name => 'LIECHTENSTEIN', :printable_name => 'Liechtenstein', :iso3 => 'LIE', :numcode => '438') <br /> Country.create(:iso => 'LT', :name => 'LITHUANIA', :printable_name => 'Lithuania', :iso3 => 'LTU', :numcode => '440') <br /> Country.create(:iso => 'LU', :name => 'LUXEMBOURG', :printable_name => 'Luxembourg', :iso3 => 'LUX', :numcode => '442') <br /> Country.create(:iso => 'MO', :name => 'MACAO', :printable_name => 'Macao', :iso3 => 'MAC', :numcode => '446') <br /> Country.create(:iso => 'MK', :name => 'MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF', :printable_name => 'Macedonia, the Former Yugoslav Republic of', :iso3 => 'MKD', :numcode => '807') <br /> Country.create(:iso => 'MG', :name => 'MADAGASCAR', :printable_name => 'Madagascar', :iso3 => 'MDG', :numcode => '450') <br /> Country.create(:iso => 'MW', :name => 'MALAWI', :printable_name => 'Malawi', :iso3 => 'MWI', :numcode => '454') <br /> Country.create(:iso => 'MY', :name => 'MALAYSIA', :printable_name => 'Malaysia', :iso3 => 'MYS', :numcode => '458') <br /> Country.create(:iso => 'MV', :name => 'MALDIVES', :printable_name => 'Maldives', :iso3 => 'MDV', :numcode => '462') <br /> Country.create(:iso => 'ML', :name => 'MALI', :printable_name => 'Mali', :iso3 => 'MLI', :numcode => '466') <br /> Country.create(:iso => 'MT', :name => 'MALTA', :printable_name => 'Malta', :iso3 => 'MLT', :numcode => '470') <br /> Country.create(:iso => 'MH', :name => 'MARSHALL ISLANDS', :printable_name => 'Marshall Islands', :iso3 => 'MHL', :numcode => '584') <br /> Country.create(:iso => 'MQ', :name => 'MARTINIQUE', :printable_name => 'Martinique', :iso3 => 'MTQ', :numcode => '474') <br /> Country.create(:iso => 'MR', :name => 'MAURITANIA', :printable_name => 'Mauritania', :iso3 => 'MRT', :numcode => '478') <br /> Country.create(:iso => 'MU', :name => 'MAURITIUS', :printable_name => 'Mauritius', :iso3 => 'MUS', :numcode => '480') <br /> Country.create(:iso => 'MX', :name => 'MEXICO', :printable_name => 'Mexico', :iso3 => 'MEX', :numcode => '484') <br /> Country.create(:iso => 'FM', :name => 'MICRONESIA, FEDERATED STATES OF', :printable_name => 'Micronesia, Federated States of', :iso3 => 'FSM', :numcode => '583') <br /> Country.create(:iso => 'MD', :name => 'MOLDOVA, REPUBLIC OF', :printable_name => 'Moldova, Republic of', :iso3 => 'MDA', :numcode => '498') <br /> Country.create(:iso => 'MC', :name => 'MONACO', :printable_name => 'Monaco', :iso3 => 'MCO', :numcode => '492') <br /> Country.create(:iso => 'MN', :name => 'MONGOLIA', :printable_name => 'Mongolia', :iso3 => 'MNG', :numcode => '496') <br /> Country.create(:iso => 'MS', :name => 'MONTSERRAT', :printable_name => 'Montserrat', :iso3 => 'MSR', :numcode => '500') <br /> Country.create(:iso => 'MA', :name => 'MOROCCO', :printable_name => 'Morocco', :iso3 => 'MAR', :numcode => '504') <br /> Country.create(:iso => 'MZ', :name => 'MOZAMBIQUE', :printable_name => 'Mozambique', :iso3 => 'MOZ', :numcode => '508') <br /> Country.create(:iso => 'MM', :name => 'MYANMAR', :printable_name => 'Myanmar', :iso3 => 'MMR', :numcode => '104') <br /> Country.create(:iso => 'NA', :name => 'NAMIBIA', :printable_name => 'Namibia', :iso3 => 'NAM', :numcode => '516') <br /> Country.create(:iso => 'NR', :name => 'NAURU', :printable_name => 'Nauru', :iso3 => 'NRU', :numcode => '520') <br /> Country.create(:iso => 'NP', :name => 'NEPAL', :printable_name => 'Nepal', :iso3 => 'NPL', :numcode => '524') <br /> Country.create(:iso => 'NL', :name => 'NETHERLANDS', :printable_name => 'Netherlands', :iso3 => 'NLD', :numcode => '528') <br /> Country.create(:iso => 'AN', :name => 'NETHERLANDS ANTILLES', :printable_name => 'Netherlands Antilles', :iso3 => 'ANT', :numcode => '530') <br /> Country.create(:iso => 'NC', :name => 'NEW CALEDONIA', :printable_name => 'New Caledonia', :iso3 => 'NCL', :numcode => '540') <br /> Country.create(:iso => 'NZ', :name => 'NEW ZEALAND', :printable_name => 'New Zealand', :iso3 => 'NZL', :numcode => '554') <br /> Country.create(:iso => 'NI', :name => 'NICARAGUA', :printable_name => 'Nicaragua', :iso3 => 'NIC', :numcode => '558') <br /> Country.create(:iso => 'NE', :name => 'NIGER', :printable_name => 'Niger', :iso3 => 'NER', :numcode => '562') <br /> Country.create(:iso => 'NG', :name => 'NIGERIA', :printable_name => 'Nigeria', :iso3 => 'NGA', :numcode => '566') <br /> Country.create(:iso => 'NU', :name => 'NIUE', :printable_name => 'Niue', :iso3 => 'NIU', :numcode => '570') <br /> Country.create(:iso => 'NF', :name => 'NORFOLK ISLAND', :printable_name => 'Norfolk Island', :iso3 => 'NFK', :numcode => '574') <br /> Country.create(:iso => 'MP', :name => 'NORTHERN MARIANA ISLANDS', :printable_name => 'Northern Mariana Islands', :iso3 => 'MNP', :numcode => '580') <br /> Country.create(:iso => 'NO', :name => 'NORWAY', :printable_name => 'Norway', :iso3 => 'NOR', :numcode => '578') <br /> Country.create(:iso => 'OM', :name => 'OMAN', :printable_name => 'Oman', :iso3 => 'OMN', :numcode => '512') <br /> Country.create(:iso => 'PK', :name => 'PAKISTAN', :printable_name => 'Pakistan', :iso3 => 'PAK', :numcode => '586') <br /> Country.create(:iso => 'PW', :name => 'PALAU', :printable_name => 'Palau', :iso3 => 'PLW', :numcode => '585') <br /> Country.create(:iso => 'PA', :name => 'PANAMA', :printable_name => 'Panama', :iso3 => 'PAN', :numcode => '591') <br /> Country.create(:iso => 'PG', :name => 'PAPUA NEW GUINEA', :printable_name => 'Papua New Guinea', :iso3 => 'PNG', :numcode => '598') <br /> Country.create(:iso => 'PY', :name => 'PARAGUAY', :printable_name => 'Paraguay', :iso3 => 'PRY', :numcode => '600') <br /> Country.create(:iso => 'PE', :name => 'PERU', :printable_name => 'Peru', :iso3 => 'PER', :numcode => '604') <br /> Country.create(:iso => 'PH', :name => 'PHILIPPINES', :printable_name => 'Philippines', :iso3 => 'PHL', :numcode => '608') <br /> Country.create(:iso => 'PN', :name => 'PITCAIRN', :printable_name => 'Pitcairn', :iso3 => 'PCN', :numcode => '612') <br /> Country.create(:iso => 'PL', :name => 'POLAND', :printable_name => 'Poland', :iso3 => 'POL', :numcode => '616') <br /> Country.create(:iso => 'PT', :name => 'PORTUGAL', :printable_name => 'Portugal', :iso3 => 'PRT', :numcode => '620') <br /> Country.create(:iso => 'PR', :name => 'PUERTO RICO', :printable_name => 'Puerto Rico', :iso3 => 'PRI', :numcode => '630') <br /> Country.create(:iso => 'QA', :name => 'QATAR', :printable_name => 'Qatar', :iso3 => 'QAT', :numcode => '634') <br /> Country.create(:iso => 'RE', :name => 'REUNION', :printable_name => 'Reunion', :iso3 => 'REU', :numcode => '638') <br /> Country.create(:iso => 'RO', :name => 'ROMANIA', :printable_name => 'Romania', :iso3 => 'ROM', :numcode => '642') <br /> Country.create(:iso => 'RU', :name => 'RUSSIAN FEDERATION', :printable_name => 'Russian Federation', :iso3 => 'RUS', :numcode => '643') <br /> Country.create(:iso => 'RW', :name => 'RWANDA', :printable_name => 'Rwanda', :iso3 => 'RWA', :numcode => '646') <br /> Country.create(:iso => 'SH', :name => 'SAINT HELENA', :printable_name => 'Saint Helena', :iso3 => 'SHN', :numcode => '654') <br /> Country.create(:iso => 'KN', :name => 'SAINT KITTS AND NEVIS', :printable_name => 'Saint Kitts and Nevis', :iso3 => 'KNA', :numcode => '659') <br /> Country.create(:iso => 'LC', :name => 'SAINT LUCIA', :printable_name => 'Saint Lucia', :iso3 => 'LCA', :numcode => '662') <br /> Country.create(:iso => 'PM', :name => 'SAINT PIERRE AND MIQUELON', :printable_name => 'Saint Pierre and Miquelon', :iso3 => 'SPM', :numcode => '666') <br /> Country.create(:iso => 'VC', :name => 'SAINT VINCENT AND THE GRENADINES', :printable_name => 'Saint Vincent and the Grenadines', :iso3 => 'VCT', :numcode => '670') <br /> Country.create(:iso => 'WS', :name => 'SAMOA', :printable_name => 'Samoa', :iso3 => 'WSM', :numcode => '882') <br /> Country.create(:iso => 'SM', :name => 'SAN MARINO', :printable_name => 'San Marino', :iso3 => 'SMR', :numcode => '674') <br /> Country.create(:iso => 'ST', :name => 'SAO TOME AND PRINCIPE', :printable_name => 'Sao Tome and Principe', :iso3 => 'STP', :numcode => '678') <br /> Country.create(:iso => 'SA', :name => 'SAUDI ARABIA', :printable_name => 'Saudi Arabia', :iso3 => 'SAU', :numcode => '682') <br /> Country.create(:iso => 'SN', :name => 'SENEGAL', :printable_name => 'Senegal', :iso3 => 'SEN', :numcode => '686') <br /> Country.create(:iso => 'SC', :name => 'SEYCHELLES', :printable_name => 'Seychelles', :iso3 => 'SYC', :numcode => '690') <br /> Country.create(:iso => 'SL', :name => 'SIERRA LEONE', :printable_name => 'Sierra Leone', :iso3 => 'SLE', :numcode => '694') <br /> Country.create(:iso => 'SG', :name => 'SINGAPORE', :printable_name => 'Singapore', :iso3 => 'SGP', :numcode => '702') <br /> Country.create(:iso => 'SK', :name => 'SLOVAKIA', :printable_name => 'Slovakia', :iso3 => 'SVK', :numcode => '703') <br /> Country.create(:iso => 'SI', :name => 'SLOVENIA', :printable_name => 'Slovenia', :iso3 => 'SVN', :numcode => '705') <br /> Country.create(:iso => 'SB', :name => 'SOLOMON ISLANDS', :printable_name => 'Solomon Islands', :iso3 => 'SLB', :numcode => '090') <br /> Country.create(:iso => 'SO', :name => 'SOMALIA', :printable_name => 'Somalia', :iso3 => 'SOM', :numcode => '706') <br /> Country.create(:iso => 'ZA', :name => 'SOUTH AFRICA', :printable_name => 'South Africa', :iso3 => 'ZAF', :numcode => '710') <br /> Country.create(:iso => 'ES', :name => 'SPAIN', :printable_name => 'Spain', :iso3 => 'ESP', :numcode => '724') <br /> Country.create(:iso => 'LK', :name => 'SRI LANKA', :printable_name => 'Sri Lanka', :iso3 => 'LKA', :numcode => '144') <br /> Country.create(:iso => 'SD', :name => 'SUDAN', :printable_name => 'Sudan', :iso3 => 'SDN', :numcode => '736') <br /> Country.create(:iso => 'SR', :name => 'SURINAME', :printable_name => 'Suriname', :iso3 => 'SUR', :numcode => '740') <br /> Country.create(:iso => 'SJ', :name => 'SVALBARD AND JAN MAYEN', :printable_name => 'Svalbard and Jan Mayen', :iso3 => 'SJM', :numcode => '744') <br /> Country.create(:iso => 'SZ', :name => 'SWAZILAND', :printable_name => 'Swaziland', :iso3 => 'SWZ', :numcode => '748') <br /> Country.create(:iso => 'SE', :name => 'SWEDEN', :printable_name => 'Sweden', :iso3 => 'SWE', :numcode => '752') <br /> Country.create(:iso => 'CH', :name => 'SWITZERLAND', :printable_name => 'Switzerland', :iso3 => 'CHE', :numcode => '756') <br /> Country.create(:iso => 'SY', :name => 'SYRIAN ARAB REPUBLIC', :printable_name => 'Syrian Arab Republic', :iso3 => 'SYR', :numcode => '760') <br /> Country.create(:iso => 'TW', :name => 'TAIWAN, PROVINCE OF CHINA', :printable_name => 'Taiwan, Province of China', :iso3 => 'TWN', :numcode => '158') <br /> Country.create(:iso => 'TJ', :name => 'TAJIKISTAN', :printable_name => 'Tajikistan', :iso3 => 'TJK', :numcode => '762') <br /> Country.create(:iso => 'TZ', :name => 'TANZANIA, UNITED REPUBLIC OF', :printable_name => 'Tanzania, United Republic of', :iso3 => 'TZA', :numcode => '834') <br /> Country.create(:iso => 'TH', :name => 'THAILAND', :printable_name => 'Thailand', :iso3 => 'THA', :numcode => '764') <br /> Country.create(:iso => 'TG', :name => 'TOGO', :printable_name => 'Togo', :iso3 => 'TGO', :numcode => '768') <br /> Country.create(:iso => 'TK', :name => 'TOKELAU', :printable_name => 'Tokelau', :iso3 => 'TKL', :numcode => '772') <br /> Country.create(:iso => 'TO', :name => 'TONGA', :printable_name => 'Tonga', :iso3 => 'TON', :numcode => '776') <br /> Country.create(:iso => 'TT', :name => 'TRINIDAD AND TOBAGO', :printable_name => 'Trinidad and Tobago', :iso3 => 'TTO', :numcode => '780') <br /> Country.create(:iso => 'TN', :name => 'TUNISIA', :printable_name => 'Tunisia', :iso3 => 'TUN', :numcode => '788') <br /> Country.create(:iso => 'TR', :name => 'TURKEY', :printable_name => 'Turkey', :iso3 => 'TUR', :numcode => '792') <br /> Country.create(:iso => 'TM', :name => 'TURKMENISTAN', :printable_name => 'Turkmenistan', :iso3 => 'TKM', :numcode => '795') <br /> Country.create(:iso => 'TC', :name => 'TURKS AND CAICOS ISLANDS', :printable_name => 'Turks and Caicos Islands', :iso3 => 'TCA', :numcode => '796') <br /> Country.create(:iso => 'TV', :name => 'TUVALU', :printable_name => 'Tuvalu', :iso3 => 'TUV', :numcode => '798') <br /> Country.create(:iso => 'UG', :name => 'UGANDA', :printable_name => 'Uganda', :iso3 => 'UGA', :numcode => '800') <br /> Country.create(:iso => 'UA', :name => 'UKRAINE', :printable_name => 'Ukraine', :iso3 => 'UKR', :numcode => '804') <br /> Country.create(:iso => 'AE', :name => 'UNITED ARAB EMIRATES', :printable_name => 'United Arab Emirates', :iso3 => 'ARE', :numcode => '784') <br /> Country.create(:iso => 'GB', :name => 'UNITED KINGDOM', :printable_name => 'United Kingdom', :iso3 => 'GBR', :numcode => '826') <br /> Country.create(:iso => 'US', :name => 'UNITED STATES', :printable_name => 'United States', :iso3 => 'USA', :numcode => '840') <br /> Country.create(:iso => 'UY', :name => 'URUGUAY', :printable_name => 'Uruguay', :iso3 => 'URY', :numcode => '858') <br /> Country.create(:iso => 'UZ', :name => 'UZBEKISTAN', :printable_name => 'Uzbekistan', :iso3 => 'UZB', :numcode => '860') <br /> Country.create(:iso => 'VU', :name => 'VANUATU', :printable_name => 'Vanuatu', :iso3 => 'VUT', :numcode => '548') <br /> Country.create(:iso => 'VE', :name => 'VENEZUELA', :printable_name => 'Venezuela', :iso3 => 'VEN', :numcode => '862') <br /> Country.create(:iso => 'VN', :name => 'VIET NAM', :printable_name => 'Viet Nam', :iso3 => 'VNM', :numcode => '704') <br /> Country.create(:iso => 'VG', :name => 'VIRGIN ISLANDS, BRITISH', :printable_name => 'Virgin Islands, British', :iso3 => 'VGB', :numcode => '092') <br /> Country.create(:iso => 'VI', :name => 'VIRGIN ISLANDS, U.S.', :printable_name => 'Virgin Islands, U.s.', :iso3 => 'VIR', :numcode => '850') <br /> Country.create(:iso => 'WF', :name => 'WALLIS AND FUTUNA', :printable_name => 'Wallis and Futuna', :iso3 => 'WLF', :numcode => '876') <br /> Country.create(:iso => 'EH', :name => 'WESTERN SAHARA', :printable_name => 'Western Sahara', :iso3 => 'ESH', :numcode => '732') <br /> Country.create(:iso => 'YE', :name => 'YEMEN', :printable_name => 'Yemen', :iso3 => 'YEM', :numcode => '887') <br /> Country.create(:iso => 'ZM', :name => 'ZAMBIA', :printable_name => 'Zambia', :iso3 => 'ZMB', :numcode => '894') <br /> Country.create(:iso => 'ZW', :name => 'ZIMBABWE', :printable_name => 'Zimbabwe', :iso3 => 'ZWE', :numcode => '716') <br /> <br /> end <br /> <br /> def self.down <br /> drop_table :countries <br /> end <br />end <br /> <br /></code> Wed, 22 Mar 2006 22:51:25 GMT http://snippets.dzone.com/posts/show/1727 jmoses (jon) http://snippets.dzone.com/posts/show/1051 This are the 2letter country codes according to ISO 3166 in German. <br />Create statement is mysql, the inserts should do anywhere. Dont forget that copy and pasting this will probably give you UTF8 encoding, depending on your browser (and butterflies in Australia) <br /> <br /><code> <br />CREATE TABLE `laendercodes` ( <br /> `code` char(2) collate latin1_bin NOT NULL default '', <br /> `name` varchar(50) collate latin1_bin NOT NULL default '', <br /> PRIMARY KEY (`code`) <br />) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_bin; <br /> <br /> <br /> <br />INSERT INTO `laendercodes` VALUES ('AF', 'Afghanistan'); <br />INSERT INTO `laendercodes` VALUES ('EG', 'Ägypten'); <br />INSERT INTO `laendercodes` VALUES ('AL', 'Albanien'); <br />INSERT INTO `laendercodes` VALUES ('DZ', 'Algerien'); <br />INSERT INTO `laendercodes` VALUES ('AD', 'Andorra'); <br />INSERT INTO `laendercodes` VALUES ('AO', 'Angola'); <br />INSERT INTO `laendercodes` VALUES ('AI', 'Anguilla'); <br />INSERT INTO `laendercodes` VALUES ('AQ', 'Antarktis'); <br />INSERT INTO `laendercodes` VALUES ('AG', 'Antigua und Barbuda'); <br />INSERT INTO `laendercodes` VALUES ('GQ', 'Äquatorial Guinea'); <br />INSERT INTO `laendercodes` VALUES ('AR', 'Argentinien'); <br />INSERT INTO `laendercodes` VALUES ('AM', 'Armenien'); <br />INSERT INTO `laendercodes` VALUES ('AW', 'Aruba'); <br />INSERT INTO `laendercodes` VALUES ('AZ', 'Aserbaidschan'); <br />INSERT INTO `laendercodes` VALUES ('ET', 'äthiopien'); <br />INSERT INTO `laendercodes` VALUES ('AU', 'Australien'); <br />INSERT INTO `laendercodes` VALUES ('BS', 'Bahamas'); <br />INSERT INTO `laendercodes` VALUES ('BH', 'Bahrain'); <br />INSERT INTO `laendercodes` VALUES ('BD', 'Bangladesh'); <br />INSERT INTO `laendercodes` VALUES ('BB', 'Barbados'); <br />INSERT INTO `laendercodes` VALUES ('BE', 'Belgien'); <br />INSERT INTO `laendercodes` VALUES ('BZ', 'Belize'); <br />INSERT INTO `laendercodes` VALUES ('BJ', 'Benin'); <br />INSERT INTO `laendercodes` VALUES ('BM', 'Bermudas'); <br />INSERT INTO `laendercodes` VALUES ('BT', 'Bhutan'); <br />INSERT INTO `laendercodes` VALUES ('MM', 'Birma'); <br />INSERT INTO `laendercodes` VALUES ('BO', 'Bolivien'); <br />INSERT INTO `laendercodes` VALUES ('BA', 'Bosnien-Herzegowina'); <br />INSERT INTO `laendercodes` VALUES ('BW', 'Botswana'); <br />INSERT INTO `laendercodes` VALUES ('BV', 'Bouvet Inseln'); <br />INSERT INTO `laendercodes` VALUES ('BR', 'Brasilien'); <br />INSERT INTO `laendercodes` VALUES ('IO', 'Britisch-Indischer Ozean'); <br />INSERT INTO `laendercodes` VALUES ('BN', 'Brunei'); <br />INSERT INTO `laendercodes` VALUES ('BG', 'Bulgarien'); <br />INSERT INTO `laendercodes` VALUES ('BF', 'Burkina Faso'); <br />INSERT INTO `laendercodes` VALUES ('BI', 'Burundi'); <br />INSERT INTO `laendercodes` VALUES ('CL', 'Chile'); <br />INSERT INTO `laendercodes` VALUES ('CN', 'China'); <br />INSERT INTO `laendercodes` VALUES ('CX', 'Christmas Island'); <br />INSERT INTO `laendercodes` VALUES ('CK', 'Cook Inseln'); <br />INSERT INTO `laendercodes` VALUES ('CR', 'Costa Rica'); <br />INSERT INTO `laendercodes` VALUES ('DK', 'Dänemark'); <br />INSERT INTO `laendercodes` VALUES ('DE', 'Deutschland'); <br />INSERT INTO `laendercodes` VALUES ('DJ', 'Djibuti'); <br />INSERT INTO `laendercodes` VALUES ('DM', 'Dominika'); <br />INSERT INTO `laendercodes` VALUES ('DO', 'Dominikanische Republik'); <br />INSERT INTO `laendercodes` VALUES ('EC', 'Ecuador'); <br />INSERT INTO `laendercodes` VALUES ('SV', 'El Salvador'); <br />INSERT INTO `laendercodes` VALUES ('CI', 'Elfenbeinküste'); <br />INSERT INTO `laendercodes` VALUES ('ER', 'Eritrea'); <br />INSERT INTO `laendercodes` VALUES ('EE', 'Estland'); <br />INSERT INTO `laendercodes` VALUES ('FK', 'Falkland Inseln'); <br />INSERT INTO `laendercodes` VALUES ('FO', 'Färöer Inseln'); <br />INSERT INTO `laendercodes` VALUES ('FJ', 'Fidschi'); <br />INSERT INTO `laendercodes` VALUES ('FI', 'Finnland'); <br />INSERT INTO `laendercodes` VALUES ('FR', 'Frankreich'); <br />INSERT INTO `laendercodes` VALUES ('GF', 'französisch Guyana'); <br />INSERT INTO `laendercodes` VALUES ('PF', 'Französisch Polynesien'); <br />INSERT INTO `laendercodes` VALUES ('TF', 'Französisches Süd-Territorium'); <br />INSERT INTO `laendercodes` VALUES ('GA', 'Gabun'); <br />INSERT INTO `laendercodes` VALUES ('GM', 'Gambia'); <br />INSERT INTO `laendercodes` VALUES ('GE', 'Georgien'); <br />INSERT INTO `laendercodes` VALUES ('GH', 'Ghana'); <br />INSERT INTO `laendercodes` VALUES ('GI', 'Gibraltar'); <br />INSERT INTO `laendercodes` VALUES ('GD', 'Grenada'); <br />INSERT INTO `laendercodes` VALUES ('GR', 'Griechenland'); <br />INSERT INTO `laendercodes` VALUES ('GL', 'Grönland'); <br />INSERT INTO `laendercodes` VALUES ('UK', 'Großbritannien'); <br />INSERT INTO `laendercodes` VALUES ('GB', 'Großbritannien (UK)'); <br />INSERT INTO `laendercodes` VALUES ('GP', 'Guadeloupe'); <br />INSERT INTO `laendercodes` VALUES ('GU', 'Guam'); <br />INSERT INTO `laendercodes` VALUES ('GT', 'Guatemala'); <br />INSERT INTO `laendercodes` VALUES ('GN', 'Guinea'); <br />INSERT INTO `laendercodes` VALUES ('GW', 'Guinea Bissau'); <br />INSERT INTO `laendercodes` VALUES ('GY', 'Guyana'); <br />INSERT INTO `laendercodes` VALUES ('HT', 'Haiti'); <br />INSERT INTO `laendercodes` VALUES ('HM', 'Heard und McDonald Islands'); <br />INSERT INTO `laendercodes` VALUES ('HN', 'Honduras'); <br />INSERT INTO `laendercodes` VALUES ('HK', 'Hong Kong'); <br />INSERT INTO `laendercodes` VALUES ('IN', 'Indien'); <br />INSERT INTO `laendercodes` VALUES ('ID', 'Indonesien'); <br />INSERT INTO `laendercodes` VALUES ('IQ', 'Irak'); <br />INSERT INTO `laendercodes` VALUES ('IR', 'Iran'); <br />INSERT INTO `laendercodes` VALUES ('IE', 'Irland'); <br />INSERT INTO `laendercodes` VALUES ('IS', 'Island'); <br />INSERT INTO `laendercodes` VALUES ('IL', 'Israel'); <br />INSERT INTO `laendercodes` VALUES ('IT', 'Italien'); <br />INSERT INTO `laendercodes` VALUES ('JM', 'Jamaika'); <br />INSERT INTO `laendercodes` VALUES ('JP', 'Japan'); <br />INSERT INTO `laendercodes` VALUES ('YE', 'Jemen'); <br />INSERT INTO `laendercodes` VALUES ('JO', 'Jordanien'); <br />INSERT INTO `laendercodes` VALUES ('YU', 'Jugoslawien'); <br />INSERT INTO `laendercodes` VALUES ('KY', 'Kaiman Inseln'); <br />INSERT INTO `laendercodes` VALUES ('KH', 'Kambodscha'); <br />INSERT INTO `laendercodes` VALUES ('CM', 'Kamerun'); <br />INSERT INTO `laendercodes` VALUES ('CA', 'Kanada'); <br />INSERT INTO `laendercodes` VALUES ('CV', 'Kap Verde'); <br />INSERT INTO `laendercodes` VALUES ('KZ', 'Kasachstan'); <br />INSERT INTO `laendercodes` VALUES ('KE', 'Kenia'); <br />INSERT INTO `laendercodes` VALUES ('KG', 'Kirgisistan'); <br />INSERT INTO `laendercodes` VALUES ('KI', 'Kiribati'); <br />INSERT INTO `laendercodes` VALUES ('CC', 'Kokosinseln'); <br />INSERT INTO `laendercodes` VALUES ('CO', 'Kolumbien'); <br />INSERT INTO `laendercodes` VALUES ('KM', 'Komoren'); <br />INSERT INTO `laendercodes` VALUES ('CG', 'Kongo'); <br />INSERT INTO `laendercodes` VALUES ('CD', 'Kongo, Demokratische Republik'); <br />INSERT INTO `laendercodes` VALUES ('HR', 'Kroatien'); <br />INSERT INTO `laendercodes` VALUES ('CU', 'Kuba'); <br />INSERT INTO `laendercodes` VALUES ('KW', 'Kuwait'); <br />INSERT INTO `laendercodes` VALUES ('LA', 'Laos'); <br />INSERT INTO `laendercodes` VALUES ('LS', 'Lesotho'); <br />INSERT INTO `laendercodes` VALUES ('LV', 'Lettland'); <br />INSERT INTO `laendercodes` VALUES ('LB', 'Libanon'); <br />INSERT INTO `laendercodes` VALUES ('LR', 'Liberia'); <br />INSERT INTO `laendercodes` VALUES ('LY', 'Libyen'); <br />INSERT INTO `laendercodes` VALUES ('LI', 'Liechtenstein'); <br />INSERT INTO `laendercodes` VALUES ('LT', 'Litauen'); <br />INSERT INTO `laendercodes` VALUES ('LU', 'Luxemburg'); <br />INSERT INTO `laendercodes` VALUES ('MO', 'Macao'); <br />INSERT INTO `laendercodes` VALUES ('MG', 'Madagaskar'); <br />INSERT INTO `laendercodes` VALUES ('MW', 'Malawi'); <br />INSERT INTO `laendercodes` VALUES ('MY', 'Malaysia'); <br />INSERT INTO `laendercodes` VALUES ('MV', 'Malediven'); <br />INSERT INTO `laendercodes` VALUES ('ML', 'Mali'); <br />INSERT INTO `laendercodes` VALUES ('MT', 'Malta'); <br />INSERT INTO `laendercodes` VALUES ('MP', 'Marianen'); <br />INSERT INTO `laendercodes` VALUES ('MA', 'Marokko'); <br />INSERT INTO `laendercodes` VALUES ('MH', 'Marshall Inseln'); <br />INSERT INTO `laendercodes` VALUES ('MQ', 'Martinique'); <br />INSERT INTO `laendercodes` VALUES ('MR', 'Mauretanien'); <br />INSERT INTO `laendercodes` VALUES ('MU', 'Mauritius'); <br />INSERT INTO `laendercodes` VALUES ('YT', 'Mayotte'); <br />INSERT INTO `laendercodes` VALUES ('MK', 'Mazedonien'); <br />INSERT INTO `laendercodes` VALUES ('MX', 'Mexiko'); <br />INSERT INTO `laendercodes` VALUES ('FM', 'Mikronesien'); <br />INSERT INTO `laendercodes` VALUES ('MZ', 'Mocambique'); <br />INSERT INTO `laendercodes` VALUES ('MD', 'Moldavien'); <br />INSERT INTO `laendercodes` VALUES ('MC', 'Monaco'); <br />INSERT INTO `laendercodes` VALUES ('MN', 'Mongolei'); <br />INSERT INTO `laendercodes` VALUES ('MS', 'Montserrat'); <br />INSERT INTO `laendercodes` VALUES ('NA', 'Namibia'); <br />INSERT INTO `laendercodes` VALUES ('NR', 'Nauru'); <br />INSERT INTO `laendercodes` VALUES ('NP', 'Nepal'); <br />INSERT INTO `laendercodes` VALUES ('NC', 'Neukaledonien'); <br />INSERT INTO `laendercodes` VALUES ('NZ', 'Neuseeland'); <br />INSERT INTO `laendercodes` VALUES ('NI', 'Nicaragua'); <br />INSERT INTO `laendercodes` VALUES ('NL', 'Niederlande'); <br />INSERT INTO `laendercodes` VALUES ('AN', 'Niederländische Antillen'); <br />INSERT INTO `laendercodes` VALUES ('NE', 'Niger'); <br />INSERT INTO `laendercodes` VALUES ('NG', 'Nigeria'); <br />INSERT INTO `laendercodes` VALUES ('NU', 'Niue'); <br />INSERT INTO `laendercodes` VALUES ('KP', 'Nord Korea'); <br />INSERT INTO `laendercodes` VALUES ('NF', 'Norfolk Inseln'); <br />INSERT INTO `laendercodes` VALUES ('NO', 'Norwegen'); <br />INSERT INTO `laendercodes` VALUES ('OM', 'Oman'); <br />INSERT INTO `laendercodes` VALUES ('AT', 'österreich'); <br />INSERT INTO `laendercodes` VALUES ('PK', 'Pakistan'); <br />INSERT INTO `laendercodes` VALUES ('PS', 'Palästina'); <br />INSERT INTO `laendercodes` VALUES ('PW', 'Palau'); <br />INSERT INTO `laendercodes` VALUES ('PA', 'Panama'); <br />INSERT INTO `laendercodes` VALUES ('PG', 'Papua Neuguinea'); <br />INSERT INTO `laendercodes` VALUES ('PY', 'Paraguay'); <br />INSERT INTO `laendercodes` VALUES ('PE', 'Peru'); <br />INSERT INTO `laendercodes` VALUES ('PH', 'Philippinen'); <br />INSERT INTO `laendercodes` VALUES ('PN', 'Pitcairn'); <br />INSERT INTO `laendercodes` VALUES ('PL', 'Polen'); <br />INSERT INTO `laendercodes` VALUES ('PT', 'Portugal'); <br />INSERT INTO `laendercodes` VALUES ('PR', 'Puerto Rico'); <br />INSERT INTO `laendercodes` VALUES ('QA', 'Qatar'); <br />INSERT INTO `laendercodes` VALUES ('RE', 'Reunion'); <br />INSERT INTO `laendercodes` VALUES ('RW', 'Ruanda'); <br />INSERT INTO `laendercodes` VALUES ('RO', 'Rumänien'); <br />INSERT INTO `laendercodes` VALUES ('RU', 'Rußland'); <br />INSERT INTO `laendercodes` VALUES ('LC', 'Saint Lucia'); <br />INSERT INTO `laendercodes` VALUES ('ZM', 'Sambia'); <br />INSERT INTO `laendercodes` VALUES ('AS', 'Samoa'); <br />INSERT INTO `laendercodes` VALUES ('WS', 'Samoa'); <br />INSERT INTO `laendercodes` VALUES ('SM', 'San Marino'); <br />INSERT INTO `laendercodes` VALUES ('ST', 'Sao Tome'); <br />INSERT INTO `laendercodes` VALUES ('SA', 'Saudi Arabien'); <br />INSERT INTO `laendercodes` VALUES ('SE', 'Schweden'); <br />INSERT INTO `laendercodes` VALUES ('CH', 'Schweiz'); <br />INSERT INTO `laendercodes` VALUES ('SN', 'Senegal'); <br />INSERT INTO `laendercodes` VALUES ('SC', 'Seychellen'); <br />INSERT INTO `laendercodes` VALUES ('SL', 'Sierra Leone'); <br />INSERT INTO `laendercodes` VALUES ('SG', 'Singapur'); <br />INSERT INTO `laendercodes` VALUES ('SK', 'Slowakei -slowakische Republik-'); <br />INSERT INTO `laendercodes` VALUES ('SI', 'Slowenien'); <br />INSERT INTO `laendercodes` VALUES ('SB', 'Solomon Inseln'); <br />INSERT INTO `laendercodes` VALUES ('SO', 'Somalia'); <br />INSERT INTO `laendercodes` VALUES ('GS', 'South Georgia, South Sandwich Isl.'); <br />INSERT INTO `laendercodes` VALUES ('ES', 'Spanien'); <br />INSERT INTO `laendercodes` VALUES ('LK', 'Sri Lanka'); <br />INSERT INTO `laendercodes` VALUES ('SH', 'St. Helena'); <br />INSERT INTO `laendercodes` VALUES ('KN', 'St. Kitts Nevis Anguilla'); <br />INSERT INTO `laendercodes` VALUES ('PM', 'St. Pierre und Miquelon'); <br />INSERT INTO `laendercodes` VALUES ('VC', 'St. Vincent'); <br />INSERT INTO `laendercodes` VALUES ('KR', 'Süd Korea'); <br />INSERT INTO `laendercodes` VALUES ('ZA', 'Südafrika'); <br />INSERT INTO `laendercodes` VALUES ('SD', 'Sudan'); <br />INSERT INTO `laendercodes` VALUES ('SR', 'Surinam'); <br />INSERT INTO `laendercodes` VALUES ('SJ', 'Svalbard und Jan Mayen Islands'); <br />INSERT INTO `laendercodes` VALUES ('SZ', 'Swasiland'); <br />INSERT INTO `laendercodes` VALUES ('SY', 'Syrien'); <br />INSERT INTO `laendercodes` VALUES ('TJ', 'Tadschikistan'); <br />INSERT INTO `laendercodes` VALUES ('TW', 'Taiwan'); <br />INSERT INTO `laendercodes` VALUES ('TZ', 'Tansania'); <br />INSERT INTO `laendercodes` VALUES ('TH', 'Thailand'); <br />INSERT INTO `laendercodes` VALUES ('TP', 'Timor'); <br />INSERT INTO `laendercodes` VALUES ('TG', 'Togo'); <br />INSERT INTO `laendercodes` VALUES ('TK', 'Tokelau'); <br />INSERT INTO `laendercodes` VALUES ('TO', 'Tonga'); <br />INSERT INTO `laendercodes` VALUES ('TT', 'Trinidad Tobago'); <br />INSERT INTO `laendercodes` VALUES ('TD', 'Tschad'); <br />INSERT INTO `laendercodes` VALUES ('CZ', 'Tschechische Republik'); <br />INSERT INTO `laendercodes` VALUES ('TN', 'Tunesien'); <br />INSERT INTO `laendercodes` VALUES ('TR', 'Türkei'); <br />INSERT INTO `laendercodes` VALUES ('TM', 'Turkmenistan'); <br />INSERT INTO `laendercodes` VALUES ('TC', 'Turks und Kaikos Inseln'); <br />INSERT INTO `laendercodes` VALUES ('TV', 'Tuvalu'); <br />INSERT INTO `laendercodes` VALUES ('UG', 'Uganda'); <br />INSERT INTO `laendercodes` VALUES ('UA', 'Ukraine'); <br />INSERT INTO `laendercodes` VALUES ('HU', 'Ungarn'); <br />INSERT INTO `laendercodes` VALUES ('UY', 'Uruguay'); <br />INSERT INTO `laendercodes` VALUES ('UZ', 'Usbekistan'); <br />INSERT INTO `laendercodes` VALUES ('VU', 'Vanuatu'); <br />INSERT INTO `laendercodes` VALUES ('VA', 'Vatikan'); <br />INSERT INTO `laendercodes` VALUES ('VE', 'Venezuela'); <br />INSERT INTO `laendercodes` VALUES ('AE', 'Vereinigte Arabische Emirate'); <br />INSERT INTO `laendercodes` VALUES ('US', 'Vereinigte Staaten von Amerika'); <br />INSERT INTO `laendercodes` VALUES ('VN', 'Vietnam'); <br />INSERT INTO `laendercodes` VALUES ('VG', 'Virgin Island (Brit.)'); <br />INSERT INTO `laendercodes` VALUES ('VI', 'Virgin Island (USA)'); <br />INSERT INTO `laendercodes` VALUES ('WF', 'Wallis et Futuna'); <br />INSERT INTO `laendercodes` VALUES ('BY', 'Weissrussland'); <br />INSERT INTO `laendercodes` VALUES ('EH', 'Westsahara'); <br />INSERT INTO `laendercodes` VALUES ('CF', 'Zentralafrikanische Republik'); <br />INSERT INTO `laendercodes` VALUES ('ZW', 'Zimbabwe'); <br />INSERT INTO `laendercodes` VALUES ('CY', 'Zypern'); <br /></code> Wed, 04 Jan 2006 17:25:42 GMT http://snippets.dzone.com/posts/show/1051 jevv ()