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 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)
1 2 CREATE TABLE `laendercodes` ( 3 `code` char(2) collate latin1_bin NOT NULL default '', 4 `name` varchar(50) collate latin1_bin NOT NULL default '', 5 PRIMARY KEY (`code`) 6 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_bin; 7 8 9 10 INSERT INTO `laendercodes` VALUES ('AF', 'Afghanistan'); 11 INSERT INTO `laendercodes` VALUES ('EG', 'Ägypten'); 12 INSERT INTO `laendercodes` VALUES ('AL', 'Albanien'); 13 INSERT INTO `laendercodes` VALUES ('DZ', 'Algerien'); 14 INSERT INTO `laendercodes` VALUES ('AD', 'Andorra'); 15 INSERT INTO `laendercodes` VALUES ('AO', 'Angola'); 16 INSERT INTO `laendercodes` VALUES ('AI', 'Anguilla'); 17 INSERT INTO `laendercodes` VALUES ('AQ', 'Antarktis'); 18 INSERT INTO `laendercodes` VALUES ('AG', 'Antigua und Barbuda'); 19 INSERT INTO `laendercodes` VALUES ('GQ', 'Äquatorial Guinea'); 20 INSERT INTO `laendercodes` VALUES ('AR', 'Argentinien'); 21 INSERT INTO `laendercodes` VALUES ('AM', 'Armenien'); 22 INSERT INTO `laendercodes` VALUES ('AW', 'Aruba'); 23 INSERT INTO `laendercodes` VALUES ('AZ', 'Aserbaidschan'); 24 INSERT INTO `laendercodes` VALUES ('ET', 'äthiopien'); 25 INSERT INTO `laendercodes` VALUES ('AU', 'Australien'); 26 INSERT INTO `laendercodes` VALUES ('BS', 'Bahamas'); 27 INSERT INTO `laendercodes` VALUES ('BH', 'Bahrain'); 28 INSERT INTO `laendercodes` VALUES ('BD', 'Bangladesh'); 29 INSERT INTO `laendercodes` VALUES ('BB', 'Barbados'); 30 INSERT INTO `laendercodes` VALUES ('BE', 'Belgien'); 31 INSERT INTO `laendercodes` VALUES ('BZ', 'Belize'); 32 INSERT INTO `laendercodes` VALUES ('BJ', 'Benin'); 33 INSERT INTO `laendercodes` VALUES ('BM', 'Bermudas'); 34 INSERT INTO `laendercodes` VALUES ('BT', 'Bhutan'); 35 INSERT INTO `laendercodes` VALUES ('MM', 'Birma'); 36 INSERT INTO `laendercodes` VALUES ('BO', 'Bolivien'); 37 INSERT INTO `laendercodes` VALUES ('BA', 'Bosnien-Herzegowina'); 38 INSERT INTO `laendercodes` VALUES ('BW', 'Botswana'); 39 INSERT INTO `laendercodes` VALUES ('BV', 'Bouvet Inseln'); 40 INSERT INTO `laendercodes` VALUES ('BR', 'Brasilien'); 41 INSERT INTO `laendercodes` VALUES ('IO', 'Britisch-Indischer Ozean'); 42 INSERT INTO `laendercodes` VALUES ('BN', 'Brunei'); 43 INSERT INTO `laendercodes` VALUES ('BG', 'Bulgarien'); 44 INSERT INTO `laendercodes` VALUES ('BF', 'Burkina Faso'); 45 INSERT INTO `laendercodes` VALUES ('BI', 'Burundi'); 46 INSERT INTO `laendercodes` VALUES ('CL', 'Chile'); 47 INSERT INTO `laendercodes` VALUES ('CN', 'China'); 48 INSERT INTO `laendercodes` VALUES ('CX', 'Christmas Island'); 49 INSERT INTO `laendercodes` VALUES ('CK', 'Cook Inseln'); 50 INSERT INTO `laendercodes` VALUES ('CR', 'Costa Rica'); 51 INSERT INTO `laendercodes` VALUES ('DK', 'Dänemark'); 52 INSERT INTO `laendercodes` VALUES ('DE', 'Deutschland'); 53 INSERT INTO `laendercodes` VALUES ('DJ', 'Djibuti'); 54 INSERT INTO `laendercodes` VALUES ('DM', 'Dominika'); 55 INSERT INTO `laendercodes` VALUES ('DO', 'Dominikanische Republik'); 56 INSERT INTO `laendercodes` VALUES ('EC', 'Ecuador'); 57 INSERT INTO `laendercodes` VALUES ('SV', 'El Salvador'); 58 INSERT INTO `laendercodes` VALUES ('CI', 'Elfenbeinküste'); 59 INSERT INTO `laendercodes` VALUES ('ER', 'Eritrea'); 60 INSERT INTO `laendercodes` VALUES ('EE', 'Estland'); 61 INSERT INTO `laendercodes` VALUES ('FK', 'Falkland Inseln'); 62 INSERT INTO `laendercodes` VALUES ('FO', 'Färöer Inseln'); 63 INSERT INTO `laendercodes` VALUES ('FJ', 'Fidschi'); 64 INSERT INTO `laendercodes` VALUES ('FI', 'Finnland'); 65 INSERT INTO `laendercodes` VALUES ('FR', 'Frankreich'); 66 INSERT INTO `laendercodes` VALUES ('GF', 'französisch Guyana'); 67 INSERT INTO `laendercodes` VALUES ('PF', 'Französisch Polynesien'); 68 INSERT INTO `laendercodes` VALUES ('TF', 'Französisches Süd-Territorium'); 69 INSERT INTO `laendercodes` VALUES ('GA', 'Gabun'); 70 INSERT INTO `laendercodes` VALUES ('GM', 'Gambia'); 71 INSERT INTO `laendercodes` VALUES ('GE', 'Georgien'); 72 INSERT INTO `laendercodes` VALUES ('GH', 'Ghana'); 73 INSERT INTO `laendercodes` VALUES ('GI', 'Gibraltar'); 74 INSERT INTO `laendercodes` VALUES ('GD', 'Grenada'); 75 INSERT INTO `laendercodes` VALUES ('GR', 'Griechenland'); 76 INSERT INTO `laendercodes` VALUES ('GL', 'Grönland'); 77 INSERT INTO `laendercodes` VALUES ('UK', 'Großbritannien'); 78 INSERT INTO `laendercodes` VALUES ('GB', 'Großbritannien (UK)'); 79 INSERT INTO `laendercodes` VALUES ('GP', 'Guadeloupe'); 80 INSERT INTO `laendercodes` VALUES ('GU', 'Guam'); 81 INSERT INTO `laendercodes` VALUES ('GT', 'Guatemala'); 82 INSERT INTO `laendercodes` VALUES ('GN', 'Guinea'); 83 INSERT INTO `laendercodes` VALUES ('GW', 'Guinea Bissau'); 84 INSERT INTO `laendercodes` VALUES ('GY', 'Guyana'); 85 INSERT INTO `laendercodes` VALUES ('HT', 'Haiti'); 86 INSERT INTO `laendercodes` VALUES ('HM', 'Heard und McDonald Islands'); 87 INSERT INTO `laendercodes` VALUES ('HN', 'Honduras'); 88 INSERT INTO `laendercodes` VALUES ('HK', 'Hong Kong'); 89 INSERT INTO `laendercodes` VALUES ('IN', 'Indien'); 90 INSERT INTO `laendercodes` VALUES ('ID', 'Indonesien'); 91 INSERT INTO `laendercodes` VALUES ('IQ', 'Irak'); 92 INSERT INTO `laendercodes` VALUES ('IR', 'Iran'); 93 INSERT INTO `laendercodes` VALUES ('IE', 'Irland'); 94 INSERT INTO `laendercodes` VALUES ('IS', 'Island'); 95 INSERT INTO `laendercodes` VALUES ('IL', 'Israel'); 96 INSERT INTO `laendercodes` VALUES ('IT', 'Italien'); 97 INSERT INTO `laendercodes` VALUES ('JM', 'Jamaika'); 98 INSERT INTO `laendercodes` VALUES ('JP', 'Japan'); 99 INSERT INTO `laendercodes` VALUES ('YE', 'Jemen'); 100 INSERT INTO `laendercodes` VALUES ('JO', 'Jordanien'); 101 INSERT INTO `laendercodes` VALUES ('YU', 'Jugoslawien'); 102 INSERT INTO `laendercodes` VALUES ('KY', 'Kaiman Inseln'); 103 INSERT INTO `laendercodes` VALUES ('KH', 'Kambodscha'); 104 INSERT INTO `laendercodes` VALUES ('CM', 'Kamerun'); 105 INSERT INTO `laendercodes` VALUES ('CA', 'Kanada'); 106 INSERT INTO `laendercodes` VALUES ('CV', 'Kap Verde'); 107 INSERT INTO `laendercodes` VALUES ('KZ', 'Kasachstan'); 108 INSERT INTO `laendercodes` VALUES ('KE', 'Kenia'); 109 INSERT INTO `laendercodes` VALUES ('KG', 'Kirgisistan'); 110 INSERT INTO `laendercodes` VALUES ('KI', 'Kiribati'); 111 INSERT INTO `laendercodes` VALUES ('CC', 'Kokosinseln'); 112 INSERT INTO `laendercodes` VALUES ('CO', 'Kolumbien'); 113 INSERT INTO `laendercodes` VALUES ('KM', 'Komoren'); 114 INSERT INTO `laendercodes` VALUES ('CG', 'Kongo'); 115 INSERT INTO `laendercodes` VALUES ('CD', 'Kongo, Demokratische Republik'); 116 INSERT INTO `laendercodes` VALUES ('HR', 'Kroatien'); 117 INSERT INTO `laendercodes` VALUES ('CU', 'Kuba'); 118 INSERT INTO `laendercodes` VALUES ('KW', 'Kuwait'); 119 INSERT INTO `laendercodes` VALUES ('LA', 'Laos'); 120 INSERT INTO `laendercodes` VALUES ('LS', 'Lesotho'); 121 INSERT INTO `laendercodes` VALUES ('LV', 'Lettland'); 122 INSERT INTO `laendercodes` VALUES ('LB', 'Libanon'); 123 INSERT INTO `laendercodes` VALUES ('LR', 'Liberia'); 124 INSERT INTO `laendercodes` VALUES ('LY', 'Libyen'); 125 INSERT INTO `laendercodes` VALUES ('LI', 'Liechtenstein'); 126 INSERT INTO `laendercodes` VALUES ('LT', 'Litauen'); 127 INSERT INTO `laendercodes` VALUES ('LU', 'Luxemburg'); 128 INSERT INTO `laendercodes` VALUES ('MO', 'Macao'); 129 INSERT INTO `laendercodes` VALUES ('MG', 'Madagaskar'); 130 INSERT INTO `laendercodes` VALUES ('MW', 'Malawi'); 131 INSERT INTO `laendercodes` VALUES ('MY', 'Malaysia'); 132 INSERT INTO `laendercodes` VALUES ('MV', 'Malediven'); 133 INSERT INTO `laendercodes` VALUES ('ML', 'Mali'); 134 INSERT INTO `laendercodes` VALUES ('MT', 'Malta'); 135 INSERT INTO `laendercodes` VALUES ('MP', 'Marianen'); 136 INSERT INTO `laendercodes` VALUES ('MA', 'Marokko'); 137 INSERT INTO `laendercodes` VALUES ('MH', 'Marshall Inseln'); 138 INSERT INTO `laendercodes` VALUES ('MQ', 'Martinique'); 139 INSERT INTO `laendercodes` VALUES ('MR', 'Mauretanien'); 140 INSERT INTO `laendercodes` VALUES ('MU', 'Mauritius'); 141 INSERT INTO `laendercodes` VALUES ('YT', 'Mayotte'); 142 INSERT INTO `laendercodes` VALUES ('MK', 'Mazedonien'); 143 INSERT INTO `laendercodes` VALUES ('MX', 'Mexiko'); 144 INSERT INTO `laendercodes` VALUES ('FM', 'Mikronesien'); 145 INSERT INTO `laendercodes` VALUES ('MZ', 'Mocambique'); 146 INSERT INTO `laendercodes` VALUES ('MD', 'Moldavien'); 147 INSERT INTO `laendercodes` VALUES ('MC', 'Monaco'); 148 INSERT INTO `laendercodes` VALUES ('MN', 'Mongolei'); 149 INSERT INTO `laendercodes` VALUES ('MS', 'Montserrat'); 150 INSERT INTO `laendercodes` VALUES ('NA', 'Namibia'); 151 INSERT INTO `laendercodes` VALUES ('NR', 'Nauru'); 152 INSERT INTO `laendercodes` VALUES ('NP', 'Nepal'); 153 INSERT INTO `laendercodes` VALUES ('NC', 'Neukaledonien'); 154 INSERT INTO `laendercodes` VALUES ('NZ', 'Neuseeland'); 155 INSERT INTO `laendercodes` VALUES ('NI', 'Nicaragua'); 156 INSERT INTO `laendercodes` VALUES ('NL', 'Niederlande'); 157 INSERT INTO `laendercodes` VALUES ('AN', 'Niederländische Antillen'); 158 INSERT INTO `laendercodes` VALUES ('NE', 'Niger'); 159 INSERT INTO `laendercodes` VALUES ('NG', 'Nigeria'); 160 INSERT INTO `laendercodes` VALUES ('NU', 'Niue'); 161 INSERT INTO `laendercodes` VALUES ('KP', 'Nord Korea'); 162 INSERT INTO `laendercodes` VALUES ('NF', 'Norfolk Inseln'); 163 INSERT INTO `laendercodes` VALUES ('NO', 'Norwegen'); 164 INSERT INTO `laendercodes` VALUES ('OM', 'Oman'); 165 INSERT INTO `laendercodes` VALUES ('AT', 'österreich'); 166 INSERT INTO `laendercodes` VALUES ('PK', 'Pakistan'); 167 INSERT INTO `laendercodes` VALUES ('PS', 'Palästina'); 168 INSERT INTO `laendercodes` VALUES ('PW', 'Palau'); 169 INSERT INTO `laendercodes` VALUES ('PA', 'Panama'); 170 INSERT INTO `laendercodes` VALUES ('PG', 'Papua Neuguinea'); 171 INSERT INTO `laendercodes` VALUES ('PY', 'Paraguay'); 172 INSERT INTO `laendercodes` VALUES ('PE', 'Peru'); 173 INSERT INTO `laendercodes` VALUES ('PH', 'Philippinen'); 174 INSERT INTO `laendercodes` VALUES ('PN', 'Pitcairn'); 175 INSERT INTO `laendercodes` VALUES ('PL', 'Polen'); 176 INSERT INTO `laendercodes` VALUES ('PT', 'Portugal'); 177 INSERT INTO `laendercodes` VALUES ('PR', 'Puerto Rico'); 178 INSERT INTO `laendercodes` VALUES ('QA', 'Qatar'); 179 INSERT INTO `laendercodes` VALUES ('RE', 'Reunion'); 180 INSERT INTO `laendercodes` VALUES ('RW', 'Ruanda'); 181 INSERT INTO `laendercodes` VALUES ('RO', 'Rumänien'); 182 INSERT INTO `laendercodes` VALUES ('RU', 'Rußland'); 183 INSERT INTO `laendercodes` VALUES ('LC', 'Saint Lucia'); 184 INSERT INTO `laendercodes` VALUES ('ZM', 'Sambia'); 185 INSERT INTO `laendercodes` VALUES ('AS', 'Samoa'); 186 INSERT INTO `laendercodes` VALUES ('WS', 'Samoa'); 187 INSERT INTO `laendercodes` VALUES ('SM', 'San Marino'); 188 INSERT INTO `laendercodes` VALUES ('ST', 'Sao Tome'); 189 INSERT INTO `laendercodes` VALUES ('SA', 'Saudi Arabien'); 190 INSERT INTO `laendercodes` VALUES ('SE', 'Schweden'); 191 INSERT INTO `laendercodes` VALUES ('CH', 'Schweiz'); 192 INSERT INTO `laendercodes` VALUES ('SN', 'Senegal'); 193 INSERT INTO `laendercodes` VALUES ('SC', 'Seychellen'); 194 INSERT INTO `laendercodes` VALUES ('SL', 'Sierra Leone'); 195 INSERT INTO `laendercodes` VALUES ('SG', 'Singapur'); 196 INSERT INTO `laendercodes` VALUES ('SK', 'Slowakei -slowakische Republik-'); 197 INSERT INTO `laendercodes` VALUES ('SI', 'Slowenien'); 198 INSERT INTO `laendercodes` VALUES ('SB', 'Solomon Inseln'); 199 INSERT INTO `laendercodes` VALUES ('SO', 'Somalia'); 200 INSERT INTO `laendercodes` VALUES ('GS', 'South Georgia, South Sandwich Isl.'); 201 INSERT INTO `laendercodes` VALUES ('ES', 'Spanien'); 202 INSERT INTO `laendercodes` VALUES ('LK', 'Sri Lanka'); 203 INSERT INTO `laendercodes` VALUES ('SH', 'St. Helena'); 204 INSERT INTO `laendercodes` VALUES ('KN', 'St. Kitts Nevis Anguilla'); 205 INSERT INTO `laendercodes` VALUES ('PM', 'St. Pierre und Miquelon'); 206 INSERT INTO `laendercodes` VALUES ('VC', 'St. Vincent'); 207 INSERT INTO `laendercodes` VALUES ('KR', 'Süd Korea'); 208 INSERT INTO `laendercodes` VALUES ('ZA', 'Südafrika'); 209 INSERT INTO `laendercodes` VALUES ('SD', 'Sudan'); 210 INSERT INTO `laendercodes` VALUES ('SR', 'Surinam'); 211 INSERT INTO `laendercodes` VALUES ('SJ', 'Svalbard und Jan Mayen Islands'); 212 INSERT INTO `laendercodes` VALUES ('SZ', 'Swasiland'); 213 INSERT INTO `laendercodes` VALUES ('SY', 'Syrien'); 214 INSERT INTO `laendercodes` VALUES ('TJ', 'Tadschikistan'); 215 INSERT INTO `laendercodes` VALUES ('TW', 'Taiwan'); 216 INSERT INTO `laendercodes` VALUES ('TZ', 'Tansania'); 217 INSERT INTO `laendercodes` VALUES ('TH', 'Thailand'); 218 INSERT INTO `laendercodes` VALUES ('TP', 'Timor'); 219 INSERT INTO `laendercodes` VALUES ('TG', 'Togo'); 220 INSERT INTO `laendercodes` VALUES ('TK', 'Tokelau'); 221 INSERT INTO `laendercodes` VALUES ('TO', 'Tonga'); 222 INSERT INTO `laendercodes` VALUES ('TT', 'Trinidad Tobago'); 223 INSERT INTO `laendercodes` VALUES ('TD', 'Tschad'); 224 INSERT INTO `laendercodes` VALUES ('CZ', 'Tschechische Republik'); 225 INSERT INTO `laendercodes` VALUES ('TN', 'Tunesien'); 226 INSERT INTO `laendercodes` VALUES ('TR', 'Türkei'); 227 INSERT INTO `laendercodes` VALUES ('TM', 'Turkmenistan'); 228 INSERT INTO `laendercodes` VALUES ('TC', 'Turks und Kaikos Inseln'); 229 INSERT INTO `laendercodes` VALUES ('TV', 'Tuvalu'); 230 INSERT INTO `laendercodes` VALUES ('UG', 'Uganda'); 231 INSERT INTO `laendercodes` VALUES ('UA', 'Ukraine'); 232 INSERT INTO `laendercodes` VALUES ('HU', 'Ungarn'); 233 INSERT INTO `laendercodes` VALUES ('UY', 'Uruguay'); 234 INSERT INTO `laendercodes` VALUES ('UZ', 'Usbekistan'); 235 INSERT INTO `laendercodes` VALUES ('VU', 'Vanuatu'); 236 INSERT INTO `laendercodes` VALUES ('VA', 'Vatikan'); 237 INSERT INTO `laendercodes` VALUES ('VE', 'Venezuela'); 238 INSERT INTO `laendercodes` VALUES ('AE', 'Vereinigte Arabische Emirate'); 239 INSERT INTO `laendercodes` VALUES ('US', 'Vereinigte Staaten von Amerika'); 240 INSERT INTO `laendercodes` VALUES ('VN', 'Vietnam'); 241 INSERT INTO `laendercodes` VALUES ('VG', 'Virgin Island (Brit.)'); 242 INSERT INTO `laendercodes` VALUES ('VI', 'Virgin Island (USA)'); 243 INSERT INTO `laendercodes` VALUES ('WF', 'Wallis et Futuna'); 244 INSERT INTO `laendercodes` VALUES ('BY', 'Weissrussland'); 245 INSERT INTO `laendercodes` VALUES ('EH', 'Westsahara'); 246 INSERT INTO `laendercodes` VALUES ('CF', 'Zentralafrikanische Republik'); 247 INSERT INTO `laendercodes` VALUES ('ZW', 'Zimbabwe'); 248 INSERT INTO `laendercodes` VALUES ('CY', 'Zypern');
