DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Snippets has posted 5883 posts at DZone. View Full User Profile

Country Codes ISO-3166 German SQL

01.04.2006
| 9661 views |
  • submit to reddit
        This are the 2letter country codes according to ISO 3166 in German.
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) 

CREATE TABLE `laendercodes` (
  `code` char(2) collate latin1_bin NOT NULL default '',
  `name` varchar(50) collate latin1_bin NOT NULL default '',
  PRIMARY KEY  (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_bin;



INSERT INTO `laendercodes` VALUES ('AF', 'Afghanistan');
INSERT INTO `laendercodes` VALUES ('EG', 'Ägypten');
INSERT INTO `laendercodes` VALUES ('AL', 'Albanien');
INSERT INTO `laendercodes` VALUES ('DZ', 'Algerien');
INSERT INTO `laendercodes` VALUES ('AD', 'Andorra');
INSERT INTO `laendercodes` VALUES ('AO', 'Angola');
INSERT INTO `laendercodes` VALUES ('AI', 'Anguilla');
INSERT INTO `laendercodes` VALUES ('AQ', 'Antarktis');
INSERT INTO `laendercodes` VALUES ('AG', 'Antigua und Barbuda');
INSERT INTO `laendercodes` VALUES ('GQ', 'Äquatorial Guinea');
INSERT INTO `laendercodes` VALUES ('AR', 'Argentinien');
INSERT INTO `laendercodes` VALUES ('AM', 'Armenien');
INSERT INTO `laendercodes` VALUES ('AW', 'Aruba');
INSERT INTO `laendercodes` VALUES ('AZ', 'Aserbaidschan');
INSERT INTO `laendercodes` VALUES ('ET', 'äthiopien');
INSERT INTO `laendercodes` VALUES ('AU', 'Australien');
INSERT INTO `laendercodes` VALUES ('BS', 'Bahamas');
INSERT INTO `laendercodes` VALUES ('BH', 'Bahrain');
INSERT INTO `laendercodes` VALUES ('BD', 'Bangladesh');
INSERT INTO `laendercodes` VALUES ('BB', 'Barbados');
INSERT INTO `laendercodes` VALUES ('BE', 'Belgien');
INSERT INTO `laendercodes` VALUES ('BZ', 'Belize');
INSERT INTO `laendercodes` VALUES ('BJ', 'Benin');
INSERT INTO `laendercodes` VALUES ('BM', 'Bermudas');
INSERT INTO `laendercodes` VALUES ('BT', 'Bhutan');
INSERT INTO `laendercodes` VALUES ('MM', 'Birma');
INSERT INTO `laendercodes` VALUES ('BO', 'Bolivien');
INSERT INTO `laendercodes` VALUES ('BA', 'Bosnien-Herzegowina');
INSERT INTO `laendercodes` VALUES ('BW', 'Botswana');
INSERT INTO `laendercodes` VALUES ('BV', 'Bouvet Inseln');
INSERT INTO `laendercodes` VALUES ('BR', 'Brasilien');
INSERT INTO `laendercodes` VALUES ('IO', 'Britisch-Indischer Ozean');
INSERT INTO `laendercodes` VALUES ('BN', 'Brunei');
INSERT INTO `laendercodes` VALUES ('BG', 'Bulgarien');
INSERT INTO `laendercodes` VALUES ('BF', 'Burkina Faso');
INSERT INTO `laendercodes` VALUES ('BI', 'Burundi');
INSERT INTO `laendercodes` VALUES ('CL', 'Chile');
INSERT INTO `laendercodes` VALUES ('CN', 'China');
INSERT INTO `laendercodes` VALUES ('CX', 'Christmas Island');
INSERT INTO `laendercodes` VALUES ('CK', 'Cook Inseln');
INSERT INTO `laendercodes` VALUES ('CR', 'Costa Rica');
INSERT INTO `laendercodes` VALUES ('DK', 'Dänemark');
INSERT INTO `laendercodes` VALUES ('DE', 'Deutschland');
INSERT INTO `laendercodes` VALUES ('DJ', 'Djibuti');
INSERT INTO `laendercodes` VALUES ('DM', 'Dominika');
INSERT INTO `laendercodes` VALUES ('DO', 'Dominikanische Republik');
INSERT INTO `laendercodes` VALUES ('EC', 'Ecuador');
INSERT INTO `laendercodes` VALUES ('SV', 'El Salvador');
INSERT INTO `laendercodes` VALUES ('CI', 'Elfenbeinküste');
INSERT INTO `laendercodes` VALUES ('ER', 'Eritrea');
INSERT INTO `laendercodes` VALUES ('EE', 'Estland');
INSERT INTO `laendercodes` VALUES ('FK', 'Falkland Inseln');
INSERT INTO `laendercodes` VALUES ('FO', 'Färöer Inseln');
INSERT INTO `laendercodes` VALUES ('FJ', 'Fidschi');
INSERT INTO `laendercodes` VALUES ('FI', 'Finnland');
INSERT INTO `laendercodes` VALUES ('FR', 'Frankreich');
INSERT INTO `laendercodes` VALUES ('GF', 'französisch Guyana');
INSERT INTO `laendercodes` VALUES ('PF', 'Französisch Polynesien');
INSERT INTO `laendercodes` VALUES ('TF', 'Französisches Süd-Territorium');
INSERT INTO `laendercodes` VALUES ('GA', 'Gabun');
INSERT INTO `laendercodes` VALUES ('GM', 'Gambia');
INSERT INTO `laendercodes` VALUES ('GE', 'Georgien');
INSERT INTO `laendercodes` VALUES ('GH', 'Ghana');
INSERT INTO `laendercodes` VALUES ('GI', 'Gibraltar');
INSERT INTO `laendercodes` VALUES ('GD', 'Grenada');
INSERT INTO `laendercodes` VALUES ('GR', 'Griechenland');
INSERT INTO `laendercodes` VALUES ('GL', 'Grönland');
INSERT INTO `laendercodes` VALUES ('UK', 'Großbritannien');
INSERT INTO `laendercodes` VALUES ('GB', 'Großbritannien (UK)');
INSERT INTO `laendercodes` VALUES ('GP', 'Guadeloupe');
INSERT INTO `laendercodes` VALUES ('GU', 'Guam');
INSERT INTO `laendercodes` VALUES ('GT', 'Guatemala');
INSERT INTO `laendercodes` VALUES ('GN', 'Guinea');
INSERT INTO `laendercodes` VALUES ('GW', 'Guinea Bissau');
INSERT INTO `laendercodes` VALUES ('GY', 'Guyana');
INSERT INTO `laendercodes` VALUES ('HT', 'Haiti');
INSERT INTO `laendercodes` VALUES ('HM', 'Heard und McDonald Islands');
INSERT INTO `laendercodes` VALUES ('HN', 'Honduras');
INSERT INTO `laendercodes` VALUES ('HK', 'Hong Kong');
INSERT INTO `laendercodes` VALUES ('IN', 'Indien');
INSERT INTO `laendercodes` VALUES ('ID', 'Indonesien');
INSERT INTO `laendercodes` VALUES ('IQ', 'Irak');
INSERT INTO `laendercodes` VALUES ('IR', 'Iran');
INSERT INTO `laendercodes` VALUES ('IE', 'Irland');
INSERT INTO `laendercodes` VALUES ('IS', 'Island');
INSERT INTO `laendercodes` VALUES ('IL', 'Israel');
INSERT INTO `laendercodes` VALUES ('IT', 'Italien');
INSERT INTO `laendercodes` VALUES ('JM', 'Jamaika');
INSERT INTO `laendercodes` VALUES ('JP', 'Japan');
INSERT INTO `laendercodes` VALUES ('YE', 'Jemen');
INSERT INTO `laendercodes` VALUES ('JO', 'Jordanien');
INSERT INTO `laendercodes` VALUES ('YU', 'Jugoslawien');
INSERT INTO `laendercodes` VALUES ('KY', 'Kaiman Inseln');
INSERT INTO `laendercodes` VALUES ('KH', 'Kambodscha');
INSERT INTO `laendercodes` VALUES ('CM', 'Kamerun');
INSERT INTO `laendercodes` VALUES ('CA', 'Kanada');
INSERT INTO `laendercodes` VALUES ('CV', 'Kap Verde');
INSERT INTO `laendercodes` VALUES ('KZ', 'Kasachstan');
INSERT INTO `laendercodes` VALUES ('KE', 'Kenia');
INSERT INTO `laendercodes` VALUES ('KG', 'Kirgisistan');
INSERT INTO `laendercodes` VALUES ('KI', 'Kiribati');
INSERT INTO `laendercodes` VALUES ('CC', 'Kokosinseln');
INSERT INTO `laendercodes` VALUES ('CO', 'Kolumbien');
INSERT INTO `laendercodes` VALUES ('KM', 'Komoren');
INSERT INTO `laendercodes` VALUES ('CG', 'Kongo');
INSERT INTO `laendercodes` VALUES ('CD', 'Kongo, Demokratische Republik');
INSERT INTO `laendercodes` VALUES ('HR', 'Kroatien');
INSERT INTO `laendercodes` VALUES ('CU', 'Kuba');
INSERT INTO `laendercodes` VALUES ('KW', 'Kuwait');
INSERT INTO `laendercodes` VALUES ('LA', 'Laos');
INSERT INTO `laendercodes` VALUES ('LS', 'Lesotho');
INSERT INTO `laendercodes` VALUES ('LV', 'Lettland');
INSERT INTO `laendercodes` VALUES ('LB', 'Libanon');
INSERT INTO `laendercodes` VALUES ('LR', 'Liberia');
INSERT INTO `laendercodes` VALUES ('LY', 'Libyen');
INSERT INTO `laendercodes` VALUES ('LI', 'Liechtenstein');
INSERT INTO `laendercodes` VALUES ('LT', 'Litauen');
INSERT INTO `laendercodes` VALUES ('LU', 'Luxemburg');
INSERT INTO `laendercodes` VALUES ('MO', 'Macao');
INSERT INTO `laendercodes` VALUES ('MG', 'Madagaskar');
INSERT INTO `laendercodes` VALUES ('MW', 'Malawi');
INSERT INTO `laendercodes` VALUES ('MY', 'Malaysia');
INSERT INTO `laendercodes` VALUES ('MV', 'Malediven');
INSERT INTO `laendercodes` VALUES ('ML', 'Mali');
INSERT INTO `laendercodes` VALUES ('MT', 'Malta');
INSERT INTO `laendercodes` VALUES ('MP', 'Marianen');
INSERT INTO `laendercodes` VALUES ('MA', 'Marokko');
INSERT INTO `laendercodes` VALUES ('MH', 'Marshall Inseln');
INSERT INTO `laendercodes` VALUES ('MQ', 'Martinique');
INSERT INTO `laendercodes` VALUES ('MR', 'Mauretanien');
INSERT INTO `laendercodes` VALUES ('MU', 'Mauritius');
INSERT INTO `laendercodes` VALUES ('YT', 'Mayotte');
INSERT INTO `laendercodes` VALUES ('MK', 'Mazedonien');
INSERT INTO `laendercodes` VALUES ('MX', 'Mexiko');
INSERT INTO `laendercodes` VALUES ('FM', 'Mikronesien');
INSERT INTO `laendercodes` VALUES ('MZ', 'Mocambique');
INSERT INTO `laendercodes` VALUES ('MD', 'Moldavien');
INSERT INTO `laendercodes` VALUES ('MC', 'Monaco');
INSERT INTO `laendercodes` VALUES ('MN', 'Mongolei');
INSERT INTO `laendercodes` VALUES ('MS', 'Montserrat');
INSERT INTO `laendercodes` VALUES ('NA', 'Namibia');
INSERT INTO `laendercodes` VALUES ('NR', 'Nauru');
INSERT INTO `laendercodes` VALUES ('NP', 'Nepal');
INSERT INTO `laendercodes` VALUES ('NC', 'Neukaledonien');
INSERT INTO `laendercodes` VALUES ('NZ', 'Neuseeland');
INSERT INTO `laendercodes` VALUES ('NI', 'Nicaragua');
INSERT INTO `laendercodes` VALUES ('NL', 'Niederlande');
INSERT INTO `laendercodes` VALUES ('AN', 'Niederländische Antillen');
INSERT INTO `laendercodes` VALUES ('NE', 'Niger');
INSERT INTO `laendercodes` VALUES ('NG', 'Nigeria');
INSERT INTO `laendercodes` VALUES ('NU', 'Niue');
INSERT INTO `laendercodes` VALUES ('KP', 'Nord Korea');
INSERT INTO `laendercodes` VALUES ('NF', 'Norfolk Inseln');
INSERT INTO `laendercodes` VALUES ('NO', 'Norwegen');
INSERT INTO `laendercodes` VALUES ('OM', 'Oman');
INSERT INTO `laendercodes` VALUES ('AT', 'österreich');
INSERT INTO `laendercodes` VALUES ('PK', 'Pakistan');
INSERT INTO `laendercodes` VALUES ('PS', 'Palästina');
INSERT INTO `laendercodes` VALUES ('PW', 'Palau');
INSERT INTO `laendercodes` VALUES ('PA', 'Panama');
INSERT INTO `laendercodes` VALUES ('PG', 'Papua Neuguinea');
INSERT INTO `laendercodes` VALUES ('PY', 'Paraguay');
INSERT INTO `laendercodes` VALUES ('PE', 'Peru');
INSERT INTO `laendercodes` VALUES ('PH', 'Philippinen');
INSERT INTO `laendercodes` VALUES ('PN', 'Pitcairn');
INSERT INTO `laendercodes` VALUES ('PL', 'Polen');
INSERT INTO `laendercodes` VALUES ('PT', 'Portugal');
INSERT INTO `laendercodes` VALUES ('PR', 'Puerto Rico');
INSERT INTO `laendercodes` VALUES ('QA', 'Qatar');
INSERT INTO `laendercodes` VALUES ('RE', 'Reunion');
INSERT INTO `laendercodes` VALUES ('RW', 'Ruanda');
INSERT INTO `laendercodes` VALUES ('RO', 'Rumänien');
INSERT INTO `laendercodes` VALUES ('RU', 'Rußland');
INSERT INTO `laendercodes` VALUES ('LC', 'Saint Lucia');
INSERT INTO `laendercodes` VALUES ('ZM', 'Sambia');
INSERT INTO `laendercodes` VALUES ('AS', 'Samoa');
INSERT INTO `laendercodes` VALUES ('WS', 'Samoa');
INSERT INTO `laendercodes` VALUES ('SM', 'San Marino');
INSERT INTO `laendercodes` VALUES ('ST', 'Sao Tome');
INSERT INTO `laendercodes` VALUES ('SA', 'Saudi Arabien');
INSERT INTO `laendercodes` VALUES ('SE', 'Schweden');
INSERT INTO `laendercodes` VALUES ('CH', 'Schweiz');
INSERT INTO `laendercodes` VALUES ('SN', 'Senegal');
INSERT INTO `laendercodes` VALUES ('SC', 'Seychellen');
INSERT INTO `laendercodes` VALUES ('SL', 'Sierra Leone');
INSERT INTO `laendercodes` VALUES ('SG', 'Singapur');
INSERT INTO `laendercodes` VALUES ('SK', 'Slowakei -slowakische Republik-');
INSERT INTO `laendercodes` VALUES ('SI', 'Slowenien');
INSERT INTO `laendercodes` VALUES ('SB', 'Solomon Inseln');
INSERT INTO `laendercodes` VALUES ('SO', 'Somalia');
INSERT INTO `laendercodes` VALUES ('GS', 'South Georgia, South Sandwich Isl.');
INSERT INTO `laendercodes` VALUES ('ES', 'Spanien');
INSERT INTO `laendercodes` VALUES ('LK', 'Sri Lanka');
INSERT INTO `laendercodes` VALUES ('SH', 'St. Helena');
INSERT INTO `laendercodes` VALUES ('KN', 'St. Kitts Nevis Anguilla');
INSERT INTO `laendercodes` VALUES ('PM', 'St. Pierre und Miquelon');
INSERT INTO `laendercodes` VALUES ('VC', 'St. Vincent');
INSERT INTO `laendercodes` VALUES ('KR', 'Süd Korea');
INSERT INTO `laendercodes` VALUES ('ZA', 'Südafrika');
INSERT INTO `laendercodes` VALUES ('SD', 'Sudan');
INSERT INTO `laendercodes` VALUES ('SR', 'Surinam');
INSERT INTO `laendercodes` VALUES ('SJ', 'Svalbard und Jan Mayen Islands');
INSERT INTO `laendercodes` VALUES ('SZ', 'Swasiland');
INSERT INTO `laendercodes` VALUES ('SY', 'Syrien');
INSERT INTO `laendercodes` VALUES ('TJ', 'Tadschikistan');
INSERT INTO `laendercodes` VALUES ('TW', 'Taiwan');
INSERT INTO `laendercodes` VALUES ('TZ', 'Tansania');
INSERT INTO `laendercodes` VALUES ('TH', 'Thailand');
INSERT INTO `laendercodes` VALUES ('TP', 'Timor');
INSERT INTO `laendercodes` VALUES ('TG', 'Togo');
INSERT INTO `laendercodes` VALUES ('TK', 'Tokelau');
INSERT INTO `laendercodes` VALUES ('TO', 'Tonga');
INSERT INTO `laendercodes` VALUES ('TT', 'Trinidad Tobago');
INSERT INTO `laendercodes` VALUES ('TD', 'Tschad');
INSERT INTO `laendercodes` VALUES ('CZ', 'Tschechische Republik');
INSERT INTO `laendercodes` VALUES ('TN', 'Tunesien');
INSERT INTO `laendercodes` VALUES ('TR', 'Türkei');
INSERT INTO `laendercodes` VALUES ('TM', 'Turkmenistan');
INSERT INTO `laendercodes` VALUES ('TC', 'Turks und Kaikos Inseln');
INSERT INTO `laendercodes` VALUES ('TV', 'Tuvalu');
INSERT INTO `laendercodes` VALUES ('UG', 'Uganda');
INSERT INTO `laendercodes` VALUES ('UA', 'Ukraine');
INSERT INTO `laendercodes` VALUES ('HU', 'Ungarn');
INSERT INTO `laendercodes` VALUES ('UY', 'Uruguay');
INSERT INTO `laendercodes` VALUES ('UZ', 'Usbekistan');
INSERT INTO `laendercodes` VALUES ('VU', 'Vanuatu');
INSERT INTO `laendercodes` VALUES ('VA', 'Vatikan');
INSERT INTO `laendercodes` VALUES ('VE', 'Venezuela');
INSERT INTO `laendercodes` VALUES ('AE', 'Vereinigte Arabische Emirate');
INSERT INTO `laendercodes` VALUES ('US', 'Vereinigte Staaten von Amerika');
INSERT INTO `laendercodes` VALUES ('VN', 'Vietnam');
INSERT INTO `laendercodes` VALUES ('VG', 'Virgin Island (Brit.)');
INSERT INTO `laendercodes` VALUES ('VI', 'Virgin Island (USA)');
INSERT INTO `laendercodes` VALUES ('WF', 'Wallis et Futuna');
INSERT INTO `laendercodes` VALUES ('BY', 'Weissrussland');
INSERT INTO `laendercodes` VALUES ('EH', 'Westsahara');
INSERT INTO `laendercodes` VALUES ('CF', 'Zentralafrikanische Republik');
INSERT INTO `laendercodes` VALUES ('ZW', 'Zimbabwe');
INSERT INTO `laendercodes` VALUES ('CY', 'Zypern');
    

Comments

Snippets Manager replied on Tue, 2009/03/03 - 9:24am

Letter(s) countries will work in any ISO-3166 SQL? For example if vacation table with flights to Israel which is in Hebrew, the IL "laendercode" should be visible in any language?