Ich habe mal in meinem Shop die Tabelle countries angepasst. Ich finde es völlig besch....eiden, dass in einem rein deutschen Shop englische Ländernamen angezeigt werden.
Die Daten stammen aus dem Thread:
http://www.modified-shop.org/forum/index.php?topic=11971.msg115088#msg115088Erweitert um den Ländercode FX
Ich hatte zuerst das in myphpadmin reinkopiert:
UPDATE countries SET countries_name='Andorra' WHERE countries_iso_code_2='AD';
UPDATE countries SET countries_name='Vereinigte Arabische Emirate' WHERE countries_iso_code_2='AE';
UPDATE countries SET countries_name='Afghanistan' WHERE countries_iso_code_2='AF';
UPDATE countries SET countries_name='Antigua Barbuda' WHERE countries_iso_code_2='AG';
UPDATE countries SET countries_name='Anguilla' WHERE countries_iso_code_2='AI';
UPDATE countries SET countries_name='Albanien' WHERE countries_iso_code_2='AL';
UPDATE countries SET countries_name='Armenien' WHERE countries_iso_code_2='AM';
UPDATE countries SET countries_name='Niederländische Antillen' WHERE countries_iso_code_2='AN';
UPDATE countries SET countries_name='Angola' WHERE countries_iso_code_2='AO';
UPDATE countries SET countries_name='Antarktis' WHERE countries_iso_code_2='AQ';
UPDATE countries SET countries_name='Argentinien' WHERE countries_iso_code_2='AR';
UPDATE countries SET countries_name='Amerikanisch Samoa' WHERE countries_iso_code_2='AS';
UPDATE countries SET countries_name='Österreich' WHERE countries_iso_code_2='AT';
UPDATE countries SET countries_name='Australien' WHERE countries_iso_code_2='AU';
UPDATE countries SET countries_name='Aruba' WHERE countries_iso_code_2='AW';
UPDATE countries SET countries_name='Aserbaidschan' WHERE countries_iso_code_2='AZ';
UPDATE countries SET countries_name='Bosnien Herzegowina' WHERE countries_iso_code_2='BA';
UPDATE countries SET countries_name='Barbados' WHERE countries_iso_code_2='BB';
UPDATE countries SET countries_name='Bangladesch' WHERE countries_iso_code_2='BD';
UPDATE countries SET countries_name='Belgien' WHERE countries_iso_code_2='BE';
UPDATE countries SET countries_name='Burkina Faso' WHERE countries_iso_code_2='BF';
UPDATE countries SET countries_name='Bulgarien' WHERE countries_iso_code_2='BG';
UPDATE countries SET countries_name='Bahrain' WHERE countries_iso_code_2='BH';
UPDATE countries SET countries_name='Burundi' WHERE countries_iso_code_2='BI';
UPDATE countries SET countries_name='Benin' WHERE countries_iso_code_2='BJ';
UPDATE countries SET countries_name='Bermuda' WHERE countries_iso_code_2='BM';
UPDATE countries SET countries_name='Brunei Darussalam' WHERE countries_iso_code_2='BN';
UPDATE countries SET countries_name='Bolivien' WHERE countries_iso_code_2='BO';
UPDATE countries SET countries_name='Brasilien' WHERE countries_iso_code_2='BR';
UPDATE countries SET countries_name='Bahamas' WHERE countries_iso_code_2='BS';
UPDATE countries SET countries_name='Bhutan' WHERE countries_iso_code_2='BT';
UPDATE countries SET countries_name='Bouvet Island' WHERE countries_iso_code_2='BV';
UPDATE countries SET countries_name='Botsuana' WHERE countries_iso_code_2='BW';
UPDATE countries SET countries_name='Belarus' WHERE countries_iso_code_2='BY';
UPDATE countries SET countries_name='Belize' WHERE countries_iso_code_2='BZ';
UPDATE countries SET countries_name='Kanada' WHERE countries_iso_code_2='CA';
UPDATE countries SET countries_name='Kokosinseln' WHERE countries_iso_code_2='CC';
UPDATE countries SET countries_name='Zaire' WHERE countries_iso_code_2='CD';
UPDATE countries SET countries_name='Zentralafrikanische Republik' WHERE countries_iso_code_2='CF';
UPDATE countries SET countries_name='Kongo' WHERE countries_iso_code_2='CG';
UPDATE countries SET countries_name='Schweiz' WHERE countries_iso_code_2='CH';
UPDATE countries SET countries_name='Cote d´Ivoire' WHERE countries_iso_code_2='CI';
UPDATE countries SET countries_name='Cookinseln' WHERE countries_iso_code_2='CK';
UPDATE countries SET countries_name='Chile' WHERE countries_iso_code_2='CL';
UPDATE countries SET countries_name='Kamerun' WHERE countries_iso_code_2='CM';
UPDATE countries SET countries_name='China VR' WHERE countries_iso_code_2='CN';
UPDATE countries SET countries_name='Kolumbien' WHERE countries_iso_code_2='CO';
UPDATE countries SET countries_name='Costa Rica' WHERE countries_iso_code_2='CR';
UPDATE countries SET countries_name='Kuba' WHERE countries_iso_code_2='CU';
UPDATE countries SET countries_name='Kap Verde' WHERE countries_iso_code_2='CV';
UPDATE countries SET countries_name='Weihnachtsinseln Indischer Ozean' WHERE countries_iso_code_2='CX';
UPDATE countries SET countries_name='Zypern' WHERE countries_iso_code_2='CY';
UPDATE countries SET countries_name='Tschechische Republik' WHERE countries_iso_code_2='CZ';
UPDATE countries SET countries_name='Deutschland' WHERE countries_iso_code_2='DE';
UPDATE countries SET countries_name='Dschibuti' WHERE countries_iso_code_2='DJ';
UPDATE countries SET countries_name='Dänemark' WHERE countries_iso_code_2='DK';
UPDATE countries SET countries_name='Dominica' WHERE countries_iso_code_2='DM';
UPDATE countries SET countries_name='Dominikanische Republik' WHERE countries_iso_code_2='DO';
UPDATE countries SET countries_name='Algerien' WHERE countries_iso_code_2='DZ';
UPDATE countries SET countries_name='Ecuador' WHERE countries_iso_code_2='EC';
UPDATE countries SET countries_name='Estland' WHERE countries_iso_code_2='EE';
UPDATE countries SET countries_name='Ägypten' WHERE countries_iso_code_2='EG';
UPDATE countries SET countries_name='West Sahara' WHERE countries_iso_code_2='EH';
UPDATE countries SET countries_name='Eritrea' WHERE countries_iso_code_2='ER';
UPDATE countries SET countries_name='Spanien' WHERE countries_iso_code_2='ES';
UPDATE countries SET countries_name='Äthiopien' WHERE countries_iso_code_2='ET';
UPDATE countries SET countries_name='Finnland' WHERE countries_iso_code_2='FI';
UPDATE countries SET countries_name='Fidschi' WHERE countries_iso_code_2='FJ';
UPDATE countries SET countries_name='Falklandinseln' WHERE countries_iso_code_2='FK';
UPDATE countries SET countries_name='Mikronesien' WHERE countries_iso_code_2='FM';
UPDATE countries SET countries_name='Färöer' WHERE countries_iso_code_2='FO';
UPDATE countries SET countries_name='Frankreich' WHERE countries_iso_code_2='FR';
UPDATE countries SET countries_name='Frankreich ohne Übersee-Départements' WHERE countries_iso_code_2='FX';
UPDATE countries SET countries_name='Gabun' WHERE countries_iso_code_2='GA';
UPDATE countries SET countries_name='Großbritannien' WHERE countries_iso_code_2='GB';
UPDATE countries SET countries_name='Grenada' WHERE countries_iso_code_2='GD';
UPDATE countries SET countries_name='Georgien' WHERE countries_iso_code_2='GE';
UPDATE countries SET countries_name='Frz Guyana' WHERE countries_iso_code_2='GF';
UPDATE countries SET countries_name='Ghana' WHERE countries_iso_code_2='GH';
UPDATE countries SET countries_name='Gibraltar' WHERE countries_iso_code_2='GI';
UPDATE countries SET countries_name='Grönland' WHERE countries_iso_code_2='GL';
UPDATE countries SET countries_name='Gambia' WHERE countries_iso_code_2='GM';
UPDATE countries SET countries_name='Guinea' WHERE countries_iso_code_2='GN';
UPDATE countries SET countries_name='Guadeloupe' WHERE countries_iso_code_2='GP';
UPDATE countries SET countries_name='Äquatorial Guniea' WHERE countries_iso_code_2='GQ';
UPDATE countries SET countries_name='Griechenland' WHERE countries_iso_code_2='GR';
UPDATE countries SET countries_name='Südgeorgien' WHERE countries_iso_code_2='GS';
UPDATE countries SET countries_name='Guatemala' WHERE countries_iso_code_2='GT';
UPDATE countries SET countries_name='Guam' WHERE countries_iso_code_2='GU';
UPDATE countries SET countries_name='Guinea Bissau' WHERE countries_iso_code_2='GW';
UPDATE countries SET countries_name='Guyana' WHERE countries_iso_code_2='GY';
UPDATE countries SET countries_name='Hongkong' WHERE countries_iso_code_2='HK';
UPDATE countries SET countries_name='Heardinsel McDonaldinseln' WHERE countries_iso_code_2='HM';
UPDATE countries SET countries_name='Honduras' WHERE countries_iso_code_2='HN';
UPDATE countries SET countries_name='Kroatien' WHERE countries_iso_code_2='HR';
UPDATE countries SET countries_name='Haiti' WHERE countries_iso_code_2='HT';
UPDATE countries SET countries_name='Ungarn' WHERE countries_iso_code_2='HU';
UPDATE countries SET countries_name='Indonesien' WHERE countries_iso_code_2='ID';
UPDATE countries SET countries_name='Irland' WHERE countries_iso_code_2='IE';
UPDATE countries SET countries_name='Israel' WHERE countries_iso_code_2='IL';
UPDATE countries SET countries_name='Indien' WHERE countries_iso_code_2='IN';
UPDATE countries SET countries_name='Tschagos Inseln' WHERE countries_iso_code_2='IO';
UPDATE countries SET countries_name='Irak' WHERE countries_iso_code_2='IQ';
UPDATE countries SET countries_name='Iran' WHERE countries_iso_code_2='IR';
UPDATE countries SET countries_name='Island' WHERE countries_iso_code_2='IS';
UPDATE countries SET countries_name='Italien' WHERE countries_iso_code_2='IT';
UPDATE countries SET countries_name='Jamaika' WHERE countries_iso_code_2='JM';
UPDATE countries SET countries_name='Jordanien' WHERE countries_iso_code_2='JO';
UPDATE countries SET countries_name='Japan' WHERE countries_iso_code_2='JP';
UPDATE countries SET countries_name='Kenia' WHERE countries_iso_code_2='KE';
UPDATE countries SET countries_name='Kirgisistan' WHERE countries_iso_code_2='KG';
UPDATE countries SET countries_name='Kambodscha' WHERE countries_iso_code_2='KH';
UPDATE countries SET countries_name='Kiribati' WHERE countries_iso_code_2='KI';
UPDATE countries SET countries_name='Komoren' WHERE countries_iso_code_2='KM';
UPDATE countries SET countries_name='St Kitts und Nevis' WHERE countries_iso_code_2='KN';
UPDATE countries SET countries_name='Korea Nord' WHERE countries_iso_code_2='KP';
UPDATE countries SET countries_name='Korea Süd' WHERE countries_iso_code_2='KR';
UPDATE countries SET countries_name='Kuwait' WHERE countries_iso_code_2='KW';
UPDATE countries SET countries_name='Kaimaninseln' WHERE countries_iso_code_2='KY';
UPDATE countries SET countries_name='Kasachstan' WHERE countries_iso_code_2='KZ';
UPDATE countries SET countries_name='Laos' WHERE countries_iso_code_2='LA';
UPDATE countries SET countries_name='Libanon' WHERE countries_iso_code_2='LB';
UPDATE countries SET countries_name='St Lucia' WHERE countries_iso_code_2='LC';
UPDATE countries SET countries_name='Liechtenstein' WHERE countries_iso_code_2='LI';
UPDATE countries SET countries_name='Sri Lanka' WHERE countries_iso_code_2='LK';
UPDATE countries SET countries_name='Liberia' WHERE countries_iso_code_2='LR';
UPDATE countries SET countries_name='Lesotho' WHERE countries_iso_code_2='LS';
UPDATE countries SET countries_name='Litauen' WHERE countries_iso_code_2='LT';
UPDATE countries SET countries_name='Luxemburg' WHERE countries_iso_code_2='LU';
UPDATE countries SET countries_name='Lettland' WHERE countries_iso_code_2='LV';
UPDATE countries SET countries_name='Libyen' WHERE countries_iso_code_2='LY';
UPDATE countries SET countries_name='Marokko' WHERE countries_iso_code_2='MA';
UPDATE countries SET countries_name='Monaco' WHERE countries_iso_code_2='MC';
UPDATE countries SET countries_name='Moldau Republik' WHERE countries_iso_code_2='MD';
UPDATE countries SET countries_name='Madagaskar' WHERE countries_iso_code_2='MG';
UPDATE countries SET countries_name='Marshallinseln' WHERE countries_iso_code_2='MH';
UPDATE countries SET countries_name='Mazedonien' WHERE countries_iso_code_2='MK';
UPDATE countries SET countries_name='Mali' WHERE countries_iso_code_2='ML';
UPDATE countries SET countries_name='Myanmar' WHERE countries_iso_code_2='MM';
UPDATE countries SET countries_name='Mongolei' WHERE countries_iso_code_2='MN';
UPDATE countries SET countries_name='Macau' WHERE countries_iso_code_2='MO';
UPDATE countries SET countries_name='Nord Mariannen' WHERE countries_iso_code_2='MP';
UPDATE countries SET countries_name='Martinique' WHERE countries_iso_code_2='MQ';
UPDATE countries SET countries_name='Mauretanien' WHERE countries_iso_code_2='MR';
UPDATE countries SET countries_name='Montserrat' WHERE countries_iso_code_2='MS';
UPDATE countries SET countries_name='Malta' WHERE countries_iso_code_2='MT';
UPDATE countries SET countries_name='Mauritius' WHERE countries_iso_code_2='MU';
UPDATE countries SET countries_name='Malediven' WHERE countries_iso_code_2='MV';
UPDATE countries SET countries_name='Malawi' WHERE countries_iso_code_2='MW';
UPDATE countries SET countries_name='Mexiko' WHERE countries_iso_code_2='MX';
UPDATE countries SET countries_name='Malaysia' WHERE countries_iso_code_2='MY';
UPDATE countries SET countries_name='Mosambik' WHERE countries_iso_code_2='MZ';
UPDATE countries SET countries_name='Namibia' WHERE countries_iso_code_2='NA';
UPDATE countries SET countries_name='Neukaledonien' WHERE countries_iso_code_2='NC';
UPDATE countries SET countries_name='Niger' WHERE countries_iso_code_2='NE';
UPDATE countries SET countries_name='Norfolkinsel' WHERE countries_iso_code_2='NF';
UPDATE countries SET countries_name='Nigeria' WHERE countries_iso_code_2='NG';
UPDATE countries SET countries_name='Nicaragua' WHERE countries_iso_code_2='NI';
UPDATE countries SET countries_name='Niederlande' WHERE countries_iso_code_2='NL';
UPDATE countries SET countries_name='Norwegen' WHERE countries_iso_code_2='NO';
UPDATE countries SET countries_name='Nepal' WHERE countries_iso_code_2='NP';
UPDATE countries SET countries_name='Nauru' WHERE countries_iso_code_2='NR';
UPDATE countries SET countries_name='Niue' WHERE countries_iso_code_2='NU';
UPDATE countries SET countries_name='Neuseeland' WHERE countries_iso_code_2='NZ';
UPDATE countries SET countries_name='Oman' WHERE countries_iso_code_2='OM';
UPDATE countries SET countries_name='Panama' WHERE countries_iso_code_2='PA';
UPDATE countries SET countries_name='Peru' WHERE countries_iso_code_2='PE';
UPDATE countries SET countries_name='Frz Polynesien' WHERE countries_iso_code_2='PF';
UPDATE countries SET countries_name='Papua Neuguinea' WHERE countries_iso_code_2='PG';
UPDATE countries SET countries_name='Philippinen' WHERE countries_iso_code_2='PH';
UPDATE countries SET countries_name='Pakistan' WHERE countries_iso_code_2='PK';
UPDATE countries SET countries_name='Polen' WHERE countries_iso_code_2='PL';
UPDATE countries SET countries_name='St Pierre und Miquelon' WHERE countries_iso_code_2='PM';
UPDATE countries SET countries_name='Pitcairn' WHERE countries_iso_code_2='PN';
UPDATE countries SET countries_name='Puerto Rico' WHERE countries_iso_code_2='PR';
UPDATE countries SET countries_name='Portugal' WHERE countries_iso_code_2='PT';
UPDATE countries SET countries_name='Palau Inseln' WHERE countries_iso_code_2='PW';
UPDATE countries SET countries_name='Paraguay' WHERE countries_iso_code_2='PY';
UPDATE countries SET countries_name='Katar' WHERE countries_iso_code_2='QA';
UPDATE countries SET countries_name='Reunion' WHERE countries_iso_code_2='RE';
UPDATE countries SET countries_name='Rumänien' WHERE countries_iso_code_2='RO';
UPDATE countries SET countries_name='Russische Föderation' WHERE countries_iso_code_2='RU';
UPDATE countries SET countries_name='Ruanda' WHERE countries_iso_code_2='RW';
UPDATE countries SET countries_name='Saudi Arabien' WHERE countries_iso_code_2='SA';
UPDATE countries SET countries_name='Salomonen' WHERE countries_iso_code_2='SB';
UPDATE countries SET countries_name='Seychellen' WHERE countries_iso_code_2='SC';
UPDATE countries SET countries_name='Sudan' WHERE countries_iso_code_2='SD';
UPDATE countries SET countries_name='Schweden' WHERE countries_iso_code_2='SE';
UPDATE countries SET countries_name='Singapur' WHERE countries_iso_code_2='SG';
UPDATE countries SET countries_name='St Helena' WHERE countries_iso_code_2='SH';
UPDATE countries SET countries_name='Slowenien' WHERE countries_iso_code_2='SI';
UPDATE countries SET countries_name='Spitzbergen' WHERE countries_iso_code_2='SJ';
UPDATE countries SET countries_name='Slowakische Republik' WHERE countries_iso_code_2='SK';
UPDATE countries SET countries_name='Sierra Leone' WHERE countries_iso_code_2='SL';
UPDATE countries SET countries_name='San Marino' WHERE countries_iso_code_2='SM';
UPDATE countries SET countries_name='Senegal' WHERE countries_iso_code_2='SN';
UPDATE countries SET countries_name='Somalia' WHERE countries_iso_code_2='SO';
UPDATE countries SET countries_name='Suriname' WHERE countries_iso_code_2='SR';
UPDATE countries SET countries_name='Sao Tome und Principe' WHERE countries_iso_code_2='ST';
UPDATE countries SET countries_name='El Salvador' WHERE countries_iso_code_2='SV';
UPDATE countries SET countries_name='Syrien' WHERE countries_iso_code_2='SY';
UPDATE countries SET countries_name='Swasiland' WHERE countries_iso_code_2='SZ';
UPDATE countries SET countries_name='Turks und Caicosinseln' WHERE countries_iso_code_2='TC';
UPDATE countries SET countries_name='Tschad' WHERE countries_iso_code_2='TD';
UPDATE countries SET countries_name='Togo' WHERE countries_iso_code_2='TG';
UPDATE countries SET countries_name='Thailand' WHERE countries_iso_code_2='TH';
UPDATE countries SET countries_name='Tadschikistan' WHERE countries_iso_code_2='TJ';
UPDATE countries SET countries_name='Tokelau' WHERE countries_iso_code_2='TK';
UPDATE countries SET countries_name='Turkmenistan' WHERE countries_iso_code_2='TM';
UPDATE countries SET countries_name='Tunesien' WHERE countries_iso_code_2='TN';
UPDATE countries SET countries_name='Tonga' WHERE countries_iso_code_2='TO';
UPDATE countries SET countries_name='Ost Timor' WHERE countries_iso_code_2='TP';
UPDATE countries SET countries_name='Türkei' WHERE countries_iso_code_2='TR';
UPDATE countries SET countries_name='Trinidad und Tobago' WHERE countries_iso_code_2='TT';
UPDATE countries SET countries_name='Tuvalu' WHERE countries_iso_code_2='TV';
UPDATE countries SET countries_name='Taiwan' WHERE countries_iso_code_2='TW';
UPDATE countries SET countries_name='Tansania' WHERE countries_iso_code_2='TZ';
UPDATE countries SET countries_name='Ukraine' WHERE countries_iso_code_2='UA';
UPDATE countries SET countries_name='Uganda' WHERE countries_iso_code_2='UG';
UPDATE countries SET countries_name='Vereinigte Staaten' WHERE countries_iso_code_2='US';
UPDATE countries SET countries_name='Uruguay' WHERE countries_iso_code_2='UY';
UPDATE countries SET countries_name='Usbekistan' WHERE countries_iso_code_2='UZ';
UPDATE countries SET countries_name='Vatikanstadt' WHERE countries_iso_code_2='VA';
UPDATE countries SET countries_name='St Vincent' WHERE countries_iso_code_2='VC';
UPDATE countries SET countries_name='Venezuela' WHERE countries_iso_code_2='VE';
UPDATE countries SET countries_name='Britische Jungferninseln' WHERE countries_iso_code_2='VG';
UPDATE countries SET countries_name='Jungferninseln Amerikanisch' WHERE countries_iso_code_2='VI';
UPDATE countries SET countries_name='Vietnam' WHERE countries_iso_code_2='VN';
UPDATE countries SET countries_name='Vanuatu' WHERE countries_iso_code_2='VU';
UPDATE countries SET countries_name='Wallis und Futuna' WHERE countries_iso_code_2='WF';
UPDATE countries SET countries_name='Samoa' WHERE countries_iso_code_2='WS';
UPDATE countries SET countries_name='Jemen' WHERE countries_iso_code_2='YE';
UPDATE countries SET countries_name='Mayotte' WHERE countries_iso_code_2='YT';
UPDATE countries SET countries_name='Jugoslawien' WHERE countries_iso_code_2='YU';
UPDATE countries SET countries_name='Südafrika' WHERE countries_iso_code_2='ZA';
UPDATE countries SET countries_name='Sambia' WHERE countries_iso_code_2='ZM';
UPDATE countries SET countries_name='Simbabwe' WHERE countries_iso_code_2='ZW';
Was aber ein Zeichensatzproblem verursacht hatte. Ist also nur für Shops zu gebrauchen die auf Unicode umgestellt haben.
Also habe ich mir das ganze einmal durch die PHP Funktion htmlentities gejagt und das kam raus:
UPDATE countries SET countries_name='Andorra' WHERE countries_iso_code_2='AD';
UPDATE countries SET countries_name='Vereinigte Arabische Emirate' WHERE countries_iso_code_2='AE';
UPDATE countries SET countries_name='Afghanistan' WHERE countries_iso_code_2='AF';
UPDATE countries SET countries_name='Antigua Barbuda' WHERE countries_iso_code_2='AG';
UPDATE countries SET countries_name='Anguilla' WHERE countries_iso_code_2='AI';
UPDATE countries SET countries_name='Albanien' WHERE countries_iso_code_2='AL';
UPDATE countries SET countries_name='Armenien' WHERE countries_iso_code_2='AM';
UPDATE countries SET countries_name='Niederländische Antillen' WHERE countries_iso_code_2='AN';
UPDATE countries SET countries_name='Angola' WHERE countries_iso_code_2='AO';
UPDATE countries SET countries_name='Antarktis' WHERE countries_iso_code_2='AQ';
UPDATE countries SET countries_name='Argentinien' WHERE countries_iso_code_2='AR';
UPDATE countries SET countries_name='Amerikanisch Samoa' WHERE countries_iso_code_2='AS';
UPDATE countries SET countries_name='Österreich' WHERE countries_iso_code_2='AT';
UPDATE countries SET countries_name='Australien' WHERE countries_iso_code_2='AU';
UPDATE countries SET countries_name='Aruba' WHERE countries_iso_code_2='AW';
UPDATE countries SET countries_name='Aserbaidschan' WHERE countries_iso_code_2='AZ';
UPDATE countries SET countries_name='Bosnien Herzegowina' WHERE countries_iso_code_2='BA';
UPDATE countries SET countries_name='Barbados' WHERE countries_iso_code_2='BB';
UPDATE countries SET countries_name='Bangladesch' WHERE countries_iso_code_2='BD';
UPDATE countries SET countries_name='Belgien' WHERE countries_iso_code_2='BE';
UPDATE countries SET countries_name='Burkina Faso' WHERE countries_iso_code_2='BF';
UPDATE countries SET countries_name='Bulgarien' WHERE countries_iso_code_2='BG';
UPDATE countries SET countries_name='Bahrain' WHERE countries_iso_code_2='BH';
UPDATE countries SET countries_name='Burundi' WHERE countries_iso_code_2='BI';
UPDATE countries SET countries_name='Benin' WHERE countries_iso_code_2='BJ';
UPDATE countries SET countries_name='Bermuda' WHERE countries_iso_code_2='BM';
UPDATE countries SET countries_name='Brunei Darussalam' WHERE countries_iso_code_2='BN';
UPDATE countries SET countries_name='Bolivien' WHERE countries_iso_code_2='BO';
UPDATE countries SET countries_name='Brasilien' WHERE countries_iso_code_2='BR';
UPDATE countries SET countries_name='Bahamas' WHERE countries_iso_code_2='BS';
UPDATE countries SET countries_name='Bhutan' WHERE countries_iso_code_2='BT';
UPDATE countries SET countries_name='Bouvet Island' WHERE countries_iso_code_2='BV';
UPDATE countries SET countries_name='Botsuana' WHERE countries_iso_code_2='BW';
UPDATE countries SET countries_name='Belarus' WHERE countries_iso_code_2='BY';
UPDATE countries SET countries_name='Belize' WHERE countries_iso_code_2='BZ';
UPDATE countries SET countries_name='Kanada' WHERE countries_iso_code_2='CA';
UPDATE countries SET countries_name='Kokosinseln' WHERE countries_iso_code_2='CC';
UPDATE countries SET countries_name='Zaire' WHERE countries_iso_code_2='CD';
UPDATE countries SET countries_name='Zentralafrikanische Republik' WHERE countries_iso_code_2='CF';
UPDATE countries SET countries_name='Kongo' WHERE countries_iso_code_2='CG';
UPDATE countries SET countries_name='Schweiz' WHERE countries_iso_code_2='CH';
UPDATE countries SET countries_name='Cote d´Ivoire' WHERE countries_iso_code_2='CI';
UPDATE countries SET countries_name='Cookinseln' WHERE countries_iso_code_2='CK';
UPDATE countries SET countries_name='Chile' WHERE countries_iso_code_2='CL';
UPDATE countries SET countries_name='Kamerun' WHERE countries_iso_code_2='CM';
UPDATE countries SET countries_name='China VR' WHERE countries_iso_code_2='CN';
UPDATE countries SET countries_name='Kolumbien' WHERE countries_iso_code_2='CO';
UPDATE countries SET countries_name='Costa Rica' WHERE countries_iso_code_2='CR';
UPDATE countries SET countries_name='Kuba' WHERE countries_iso_code_2='CU';
UPDATE countries SET countries_name='Kap Verde' WHERE countries_iso_code_2='CV';
UPDATE countries SET countries_name='Weihnachtsinseln Indischer Ozean' WHERE countries_iso_code_2='CX';
UPDATE countries SET countries_name='Zypern' WHERE countries_iso_code_2='CY';
UPDATE countries SET countries_name='Tschechische Republik' WHERE countries_iso_code_2='CZ';
UPDATE countries SET countries_name='Deutschland' WHERE countries_iso_code_2='DE';
UPDATE countries SET countries_name='Dschibuti' WHERE countries_iso_code_2='DJ';
UPDATE countries SET countries_name='Dänemark' WHERE countries_iso_code_2='DK';
UPDATE countries SET countries_name='Dominica' WHERE countries_iso_code_2='DM';
UPDATE countries SET countries_name='Dominikanische Republik' WHERE countries_iso_code_2='DO';
UPDATE countries SET countries_name='Algerien' WHERE countries_iso_code_2='DZ';
UPDATE countries SET countries_name='Ecuador' WHERE countries_iso_code_2='EC';
UPDATE countries SET countries_name='Estland' WHERE countries_iso_code_2='EE';
UPDATE countries SET countries_name='Ägypten' WHERE countries_iso_code_2='EG';
UPDATE countries SET countries_name='West Sahara' WHERE countries_iso_code_2='EH';
UPDATE countries SET countries_name='Eritrea' WHERE countries_iso_code_2='ER';
UPDATE countries SET countries_name='Spanien' WHERE countries_iso_code_2='ES';
UPDATE countries SET countries_name='Äthiopien' WHERE countries_iso_code_2='ET';
UPDATE countries SET countries_name='Finnland' WHERE countries_iso_code_2='FI';
UPDATE countries SET countries_name='Fidschi' WHERE countries_iso_code_2='FJ';
UPDATE countries SET countries_name='Falklandinseln' WHERE countries_iso_code_2='FK';
UPDATE countries SET countries_name='Mikronesien' WHERE countries_iso_code_2='FM';
UPDATE countries SET countries_name='Färöer' WHERE countries_iso_code_2='FO';
UPDATE countries SET countries_name='Frankreich' WHERE countries_iso_code_2='FR';
UPDATE countries SET countries_name='Frankreich ohne Übersee-Départements' WHERE countries_iso_code_2='FX';
UPDATE countries SET countries_name='Gabun' WHERE countries_iso_code_2='GA';
UPDATE countries SET countries_name='Großbritannien' WHERE countries_iso_code_2='GB';
UPDATE countries SET countries_name='Grenada' WHERE countries_iso_code_2='GD';
UPDATE countries SET countries_name='Georgien' WHERE countries_iso_code_2='GE';
UPDATE countries SET countries_name='Frz Guyana' WHERE countries_iso_code_2='GF';
UPDATE countries SET countries_name='Ghana' WHERE countries_iso_code_2='GH';
UPDATE countries SET countries_name='Gibraltar' WHERE countries_iso_code_2='GI';
UPDATE countries SET countries_name='Grönland' WHERE countries_iso_code_2='GL';
UPDATE countries SET countries_name='Gambia' WHERE countries_iso_code_2='GM';
UPDATE countries SET countries_name='Guinea' WHERE countries_iso_code_2='GN';
UPDATE countries SET countries_name='Guadeloupe' WHERE countries_iso_code_2='GP';
UPDATE countries SET countries_name='Äquatorial Guniea' WHERE countries_iso_code_2='GQ';
UPDATE countries SET countries_name='Griechenland' WHERE countries_iso_code_2='GR';
UPDATE countries SET countries_name='Südgeorgien' WHERE countries_iso_code_2='GS';
UPDATE countries SET countries_name='Guatemala' WHERE countries_iso_code_2='GT';
UPDATE countries SET countries_name='Guam' WHERE countries_iso_code_2='GU';
UPDATE countries SET countries_name='Guinea Bissau' WHERE countries_iso_code_2='GW';
UPDATE countries SET countries_name='Guyana' WHERE countries_iso_code_2='GY';
UPDATE countries SET countries_name='Hongkong' WHERE countries_iso_code_2='HK';
UPDATE countries SET countries_name='Heardinsel McDonaldinseln' WHERE countries_iso_code_2='HM';
UPDATE countries SET countries_name='Honduras' WHERE countries_iso_code_2='HN';
UPDATE countries SET countries_name='Kroatien' WHERE countries_iso_code_2='HR';
UPDATE countries SET countries_name='Haiti' WHERE countries_iso_code_2='HT';
UPDATE countries SET countries_name='Ungarn' WHERE countries_iso_code_2='HU';
UPDATE countries SET countries_name='Indonesien' WHERE countries_iso_code_2='ID';
UPDATE countries SET countries_name='Irland' WHERE countries_iso_code_2='IE';
UPDATE countries SET countries_name='Israel' WHERE countries_iso_code_2='IL';
UPDATE countries SET countries_name='Indien' WHERE countries_iso_code_2='IN';
UPDATE countries SET countries_name='Tschagos Inseln' WHERE countries_iso_code_2='IO';
UPDATE countries SET countries_name='Irak' WHERE countries_iso_code_2='IQ';
UPDATE countries SET countries_name='Iran' WHERE countries_iso_code_2='IR';
UPDATE countries SET countries_name='Island' WHERE countries_iso_code_2='IS';
UPDATE countries SET countries_name='Italien' WHERE countries_iso_code_2='IT';
UPDATE countries SET countries_name='Jamaika' WHERE countries_iso_code_2='JM';
UPDATE countries SET countries_name='Jordanien' WHERE countries_iso_code_2='JO';
UPDATE countries SET countries_name='Japan' WHERE countries_iso_code_2='JP';
UPDATE countries SET countries_name='Kenia' WHERE countries_iso_code_2='KE';
UPDATE countries SET countries_name='Kirgisistan' WHERE countries_iso_code_2='KG';
UPDATE countries SET countries_name='Kambodscha' WHERE countries_iso_code_2='KH';
UPDATE countries SET countries_name='Kiribati' WHERE countries_iso_code_2='KI';
UPDATE countries SET countries_name='Komoren' WHERE countries_iso_code_2='KM';
UPDATE countries SET countries_name='St Kitts und Nevis' WHERE countries_iso_code_2='KN';
UPDATE countries SET countries_name='Korea Nord' WHERE countries_iso_code_2='KP';
UPDATE countries SET countries_name='Korea Süd' WHERE countries_iso_code_2='KR';
UPDATE countries SET countries_name='Kuwait' WHERE countries_iso_code_2='KW';
UPDATE countries SET countries_name='Kaimaninseln' WHERE countries_iso_code_2='KY';
UPDATE countries SET countries_name='Kasachstan' WHERE countries_iso_code_2='KZ';
UPDATE countries SET countries_name='Laos' WHERE countries_iso_code_2='LA';
UPDATE countries SET countries_name='Libanon' WHERE countries_iso_code_2='LB';
UPDATE countries SET countries_name='St Lucia' WHERE countries_iso_code_2='LC';
UPDATE countries SET countries_name='Liechtenstein' WHERE countries_iso_code_2='LI';
UPDATE countries SET countries_name='Sri Lanka' WHERE countries_iso_code_2='LK';
UPDATE countries SET countries_name='Liberia' WHERE countries_iso_code_2='LR';
UPDATE countries SET countries_name='Lesotho' WHERE countries_iso_code_2='LS';
UPDATE countries SET countries_name='Litauen' WHERE countries_iso_code_2='LT';
UPDATE countries SET countries_name='Luxemburg' WHERE countries_iso_code_2='LU';
UPDATE countries SET countries_name='Lettland' WHERE countries_iso_code_2='LV';
UPDATE countries SET countries_name='Libyen' WHERE countries_iso_code_2='LY';
UPDATE countries SET countries_name='Marokko' WHERE countries_iso_code_2='MA';
UPDATE countries SET countries_name='Monaco' WHERE countries_iso_code_2='MC';
UPDATE countries SET countries_name='Moldau Republik' WHERE countries_iso_code_2='MD';
UPDATE countries SET countries_name='Madagaskar' WHERE countries_iso_code_2='MG';
UPDATE countries SET countries_name='Marshallinseln' WHERE countries_iso_code_2='MH';
UPDATE countries SET countries_name='Mazedonien' WHERE countries_iso_code_2='MK';
UPDATE countries SET countries_name='Mali' WHERE countries_iso_code_2='ML';
UPDATE countries SET countries_name='Myanmar' WHERE countries_iso_code_2='MM';
UPDATE countries SET countries_name='Mongolei' WHERE countries_iso_code_2='MN';
UPDATE countries SET countries_name='Macau' WHERE countries_iso_code_2='MO';
UPDATE countries SET countries_name='Nord Mariannen' WHERE countries_iso_code_2='MP';
UPDATE countries SET countries_name='Martinique' WHERE countries_iso_code_2='MQ';
UPDATE countries SET countries_name='Mauretanien' WHERE countries_iso_code_2='MR';
UPDATE countries SET countries_name='Montserrat' WHERE countries_iso_code_2='MS';
UPDATE countries SET countries_name='Malta' WHERE countries_iso_code_2='MT';
UPDATE countries SET countries_name='Mauritius' WHERE countries_iso_code_2='MU';
UPDATE countries SET countries_name='Malediven' WHERE countries_iso_code_2='MV';
UPDATE countries SET countries_name='Malawi' WHERE countries_iso_code_2='MW';
UPDATE countries SET countries_name='Mexiko' WHERE countries_iso_code_2='MX';
UPDATE countries SET countries_name='Malaysia' WHERE countries_iso_code_2='MY';
UPDATE countries SET countries_name='Mosambik' WHERE countries_iso_code_2='MZ';
UPDATE countries SET countries_name='Namibia' WHERE countries_iso_code_2='NA';
UPDATE countries SET countries_name='Neukaledonien' WHERE countries_iso_code_2='NC';
UPDATE countries SET countries_name='Niger' WHERE countries_iso_code_2='NE';
UPDATE countries SET countries_name='Norfolkinsel' WHERE countries_iso_code_2='NF';
UPDATE countries SET countries_name='Nigeria' WHERE countries_iso_code_2='NG';
UPDATE countries SET countries_name='Nicaragua' WHERE countries_iso_code_2='NI';
UPDATE countries SET countries_name='Niederlande' WHERE countries_iso_code_2='NL';
UPDATE countries SET countries_name='Norwegen' WHERE countries_iso_code_2='NO';
UPDATE countries SET countries_name='Nepal' WHERE countries_iso_code_2='NP';
UPDATE countries SET countries_name='Nauru' WHERE countries_iso_code_2='NR';
UPDATE countries SET countries_name='Niue' WHERE countries_iso_code_2='NU';
UPDATE countries SET countries_name='Neuseeland' WHERE countries_iso_code_2='NZ';
UPDATE countries SET countries_name='Oman' WHERE countries_iso_code_2='OM';
UPDATE countries SET countries_name='Panama' WHERE countries_iso_code_2='PA';
UPDATE countries SET countries_name='Peru' WHERE countries_iso_code_2='PE';
UPDATE countries SET countries_name='Frz Polynesien' WHERE countries_iso_code_2='PF';
UPDATE countries SET countries_name='Papua Neuguinea' WHERE countries_iso_code_2='PG';
UPDATE countries SET countries_name='Philippinen' WHERE countries_iso_code_2='PH';
UPDATE countries SET countries_name='Pakistan' WHERE countries_iso_code_2='PK';
UPDATE countries SET countries_name='Polen' WHERE countries_iso_code_2='PL';
UPDATE countries SET countries_name='St Pierre und Miquelon' WHERE countries_iso_code_2='PM';
UPDATE countries SET countries_name='Pitcairn' WHERE countries_iso_code_2='PN';
UPDATE countries SET countries_name='Puerto Rico' WHERE countries_iso_code_2='PR';
UPDATE countries SET countries_name='Portugal' WHERE countries_iso_code_2='PT';
UPDATE countries SET countries_name='Palau Inseln' WHERE countries_iso_code_2='PW';
UPDATE countries SET countries_name='Paraguay' WHERE countries_iso_code_2='PY';
UPDATE countries SET countries_name='Katar' WHERE countries_iso_code_2='QA';
UPDATE countries SET countries_name='Reunion' WHERE countries_iso_code_2='RE';
UPDATE countries SET countries_name='Rumänien' WHERE countries_iso_code_2='RO';
UPDATE countries SET countries_name='Russische Föderation' WHERE countries_iso_code_2='RU';
UPDATE countries SET countries_name='Ruanda' WHERE countries_iso_code_2='RW';
UPDATE countries SET countries_name='Saudi Arabien' WHERE countries_iso_code_2='SA';
UPDATE countries SET countries_name='Salomonen' WHERE countries_iso_code_2='SB';
UPDATE countries SET countries_name='Seychellen' WHERE countries_iso_code_2='SC';
UPDATE countries SET countries_name='Sudan' WHERE countries_iso_code_2='SD';
UPDATE countries SET countries_name='Schweden' WHERE countries_iso_code_2='SE';
UPDATE countries SET countries_name='Singapur' WHERE countries_iso_code_2='SG';
UPDATE countries SET countries_name='St Helena' WHERE countries_iso_code_2='SH';
UPDATE countries SET countries_name='Slowenien' WHERE countries_iso_code_2='SI';
UPDATE countries SET countries_name='Spitzbergen' WHERE countries_iso_code_2='SJ';
UPDATE countries SET countries_name='Slowakische Republik' WHERE countries_iso_code_2='SK';
UPDATE countries SET countries_name='Sierra Leone' WHERE countries_iso_code_2='SL';
UPDATE countries SET countries_name='San Marino' WHERE countries_iso_code_2='SM';
UPDATE countries SET countries_name='Senegal' WHERE countries_iso_code_2='SN';
UPDATE countries SET countries_name='Somalia' WHERE countries_iso_code_2='SO';
UPDATE countries SET countries_name='Suriname' WHERE countries_iso_code_2='SR';
UPDATE countries SET countries_name='Sao Tome und Principe' WHERE countries_iso_code_2='ST';
UPDATE countries SET countries_name='El Salvador' WHERE countries_iso_code_2='SV';
UPDATE countries SET countries_name='Syrien' WHERE countries_iso_code_2='SY';
UPDATE countries SET countries_name='Swasiland' WHERE countries_iso_code_2='SZ';
UPDATE countries SET countries_name='Turks und Caicosinseln' WHERE countries_iso_code_2='TC';
UPDATE countries SET countries_name='Tschad' WHERE countries_iso_code_2='TD';
UPDATE countries SET countries_name='Togo' WHERE countries_iso_code_2='TG';
UPDATE countries SET countries_name='Thailand' WHERE countries_iso_code_2='TH';
UPDATE countries SET countries_name='Tadschikistan' WHERE countries_iso_code_2='TJ';
UPDATE countries SET countries_name='Tokelau' WHERE countries_iso_code_2='TK';
UPDATE countries SET countries_name='Turkmenistan' WHERE countries_iso_code_2='TM';
UPDATE countries SET countries_name='Tunesien' WHERE countries_iso_code_2='TN';
UPDATE countries SET countries_name='Tonga' WHERE countries_iso_code_2='TO';
UPDATE countries SET countries_name='Ost Timor' WHERE countries_iso_code_2='TP';
UPDATE countries SET countries_name='Türkei' WHERE countries_iso_code_2='TR';
UPDATE countries SET countries_name='Trinidad und Tobago' WHERE countries_iso_code_2='TT';
UPDATE countries SET countries_name='Tuvalu' WHERE countries_iso_code_2='TV';
UPDATE countries SET countries_name='Taiwan' WHERE countries_iso_code_2='TW';
UPDATE countries SET countries_name='Tansania' WHERE countries_iso_code_2='TZ';
UPDATE countries SET countries_name='Ukraine' WHERE countries_iso_code_2='UA';
UPDATE countries SET countries_name='Uganda' WHERE countries_iso_code_2='UG';
UPDATE countries SET countries_name='Vereinigte Staaten' WHERE countries_iso_code_2='US';
UPDATE countries SET countries_name='Uruguay' WHERE countries_iso_code_2='UY';
UPDATE countries SET countries_name='Usbekistan' WHERE countries_iso_code_2='UZ';
UPDATE countries SET countries_name='Vatikanstadt' WHERE countries_iso_code_2='VA';
UPDATE countries SET countries_name='St Vincent' WHERE countries_iso_code_2='VC';
UPDATE countries SET countries_name='Venezuela' WHERE countries_iso_code_2='VE';
UPDATE countries SET countries_name='Britische Jungferninseln' WHERE countries_iso_code_2='VG';
UPDATE countries SET countries_name='Jungferninseln Amerikanisch' WHERE countries_iso_code_2='VI';
UPDATE countries SET countries_name='Vietnam' WHERE countries_iso_code_2='VN';
UPDATE countries SET countries_name='Vanuatu' WHERE countries_iso_code_2='VU';
UPDATE countries SET countries_name='Wallis und Futuna' WHERE countries_iso_code_2='WF';
UPDATE countries SET countries_name='Samoa' WHERE countries_iso_code_2='WS';
UPDATE countries SET countries_name='Jemen' WHERE countries_iso_code_2='YE';
UPDATE countries SET countries_name='Mayotte' WHERE countries_iso_code_2='YT';
UPDATE countries SET countries_name='Jugoslawien' WHERE countries_iso_code_2='YU';
UPDATE countries SET countries_name='Südafrika' WHERE countries_iso_code_2='ZA';
UPDATE countries SET countries_name='Sambia' WHERE countries_iso_code_2='ZM';
UPDATE countries SET countries_name='Simbabwe' WHERE countries_iso_code_2='ZW';
Das Funktioniert jetzt auch bei Zeichensatz iso-8859-15
Getestet in einem 1.06 und einem 1.06SP2 Shop.
Linkback: https://www.modified-shop.org/forum/index.php?topic=32005.0