/ Published in: SQL
URL: http://bcmoney-mobiletv.com/blog/2010/03/01/l10n-locales-html-select-box-and-data-sql/
Localization (L10N) is the use of approved ISO-3166 country codes for adapting or otherwise targeting content and/or applications & data to specific locales.
Expand |
Embed | Plain Text
CREATE TABLE l10n (l10n_id CHAR(2), l10n_name VARCHAR(50), l10n_locale VARCHAR(100)); INSERT INTO l10n VALUES ('AC', 'saint_helena', 'Ascension Island'); INSERT INTO l10n VALUES ('AD', 'andorra', 'Andorra'); INSERT INTO l10n VALUES ('AE', 'united_arab_emirates', 'United Arab Emirates'); INSERT INTO l10n VALUES ('AF', 'afghanistan', 'Afghanistan'); INSERT INTO l10n VALUES ('AG', 'antigua_and_barbuda', 'Antigua and Barbuda'); INSERT INTO l10n VALUES ('AI', 'anguilla', 'Anguilla'); INSERT INTO l10n VALUES ('AL', 'albania', 'Albania'); INSERT INTO l10n VALUES ('AM', 'armenia', 'Armenia'); INSERT INTO l10n VALUES ('AN', 'netherlands_antilles', 'Netherlands Antilles'); INSERT INTO l10n VALUES ('AO', 'angola', 'Angola'); INSERT INTO l10n VALUES ('AQ', 'antarctica', 'Antarctica'); INSERT INTO l10n VALUES ('AR', 'argentina', 'Argentina'); INSERT INTO l10n VALUES ('AS', 'american_samoa', 'American Samoa'); INSERT INTO l10n VALUES ('AT', 'austria', 'Austria'); INSERT INTO l10n VALUES ('AU', 'australia', 'Australia'); INSERT INTO l10n VALUES ('AW', 'aruba', 'Aruba'); INSERT INTO l10n VALUES ('AX', 'finland', 'Aland Islands'); INSERT INTO l10n VALUES ('AZ', 'azerbaijan', 'Azerbaijan'); INSERT INTO l10n VALUES ('BA', 'bosnia_and_herzegovina', 'Bosnia and Herzegovina'); INSERT INTO l10n VALUES ('BB', 'barbados', 'Barbados'); INSERT INTO l10n VALUES ('BD', 'bangladesh', 'Bangladesh'); INSERT INTO l10n VALUES ('BE', 'belgium', 'Belgium'); INSERT INTO l10n VALUES ('BF', 'burkina_faso', 'Burkina Faso'); INSERT INTO l10n VALUES ('BG', 'bulgaria', 'Bulgaria'); INSERT INTO l10n VALUES ('BH', 'bahrain', 'Bahrain'); INSERT INTO l10n VALUES ('BI', 'burundi', 'Burundi'); INSERT INTO l10n VALUES ('BJ', 'benin', 'Benin'); INSERT INTO l10n VALUES ('BM', 'bermuda', 'Bermuda'); INSERT INTO l10n VALUES ('BN', 'brunei', 'Brunei Darussalam'); INSERT INTO l10n VALUES ('BO', 'bolivia', 'Bolivia'); INSERT INTO l10n VALUES ('BR', 'brazil', 'Brazil'); INSERT INTO l10n VALUES ('BS', 'bahamas_the', 'Bahamas'); INSERT INTO l10n VALUES ('BT', 'bhutan', 'Bhutan'); INSERT INTO l10n VALUES ('BV', 'bouvet_island', 'Bouvet Island'); INSERT INTO l10n VALUES ('BW', 'botswana', 'Botswana'); INSERT INTO l10n VALUES ('BY', 'belarus', 'Belarus'); INSERT INTO l10n VALUES ('BZ', 'belize', 'Belize'); INSERT INTO l10n VALUES ('CA', 'canada', 'Canada'); INSERT INTO l10n VALUES ('CC', 'cocos_', 'Cocos (Keeling) Islands'); INSERT INTO l10n VALUES ('CD', 'congo_democratic_republic_of_the', 'Congo, Democratic Republic'); INSERT INTO l10n VALUES ('CF', 'central_african_republic', 'Central African Republic'); INSERT INTO l10n VALUES ('CG', 'congo_republic_of_the', 'Congo'); INSERT INTO l10n VALUES ('CH', 'switzerland', 'Switzerland'); INSERT INTO l10n VALUES ('CI', 'cote_divoire', 'Cote D`Ivoire (Ivory Coast)'); INSERT INTO l10n VALUES ('CK', 'cook_islands', 'Cook Islands'); INSERT INTO l10n VALUES ('CL', 'chile', 'Chile'); INSERT INTO l10n VALUES ('CM', 'cameroon', 'Cameroon'); INSERT INTO l10n VALUES ('CN', 'china', 'China'); INSERT INTO l10n VALUES ('CO', 'colombia', 'Colombia'); INSERT INTO l10n VALUES ('CR', 'costa_rica', 'Costa Rica'); INSERT INTO l10n VALUES ('CS', 'czech_republic', 'Czechoslovakia (former)'); INSERT INTO l10n VALUES ('CU', 'cuba', 'Cuba'); INSERT INTO l10n VALUES ('CV', 'cape_verde', 'Cape Verde'); INSERT INTO l10n VALUES ('CX', 'christmas_island', 'Christmas Island'); INSERT INTO l10n VALUES ('CY', 'cyprus', 'Cyprus'); INSERT INTO l10n VALUES ('CZ', 'czech_republic', 'Czech Republic'); INSERT INTO l10n VALUES ('DE', 'germany', 'Germany'); INSERT INTO l10n VALUES ('DJ', 'djibouti', 'Djibouti'); INSERT INTO l10n VALUES ('DK', 'denmark', 'Denmark'); INSERT INTO l10n VALUES ('DM', 'dominica', 'Dominica'); INSERT INTO l10n VALUES ('DO', 'dominican_republic', 'Dominican Republic'); INSERT INTO l10n VALUES ('DZ', 'algeria', 'Algeria'); INSERT INTO l10n VALUES ('EC', 'ecuador', 'Ecuador'); INSERT INTO l10n VALUES ('EE', 'estonia', 'Estonia'); INSERT INTO l10n VALUES ('EG', 'egypt', 'Egypt'); INSERT INTO l10n VALUES ('EH', 'western_sahara', 'Western Sahara'); INSERT INTO l10n VALUES ('ER', 'eritrea', 'Eritrea'); INSERT INTO l10n VALUES ('ES', 'spain', 'Spain'); INSERT INTO l10n VALUES ('ET', 'ethiopia', 'Ethiopia'); INSERT INTO l10n VALUES ('EU', 'european_union', 'European Union'); INSERT INTO l10n VALUES ('FI', 'finland', 'Finland'); INSERT INTO l10n VALUES ('FJ', 'fiji', 'Fiji'); INSERT INTO l10n VALUES ('FK', 'falkland_islands_', 'Falkland Islands (Malvinas)'); INSERT INTO l10n VALUES ('FM', 'micronesia_federated_states_of', 'Micronesia'); INSERT INTO l10n VALUES ('FO', 'faroe_islands', 'Faroe Islands'); INSERT INTO l10n VALUES ('FR', 'france', 'France'); INSERT INTO l10n VALUES ('FX', 'france', 'France, Metropolitan'); INSERT INTO l10n VALUES ('GA', 'gabon', 'Gabon'); INSERT INTO l10n VALUES ('GB', 'united_kingdom', 'Great Britain (UK)'); INSERT INTO l10n VALUES ('GD', 'grenada', 'Grenada'); INSERT INTO l10n VALUES ('GE', 'georgia', 'Georgia'); INSERT INTO l10n VALUES ('GF', 'french_guiana', 'French Guiana'); INSERT INTO l10n VALUES ('GG', 'guernsey', 'Guernsey'); INSERT INTO l10n VALUES ('GH', 'ghana', 'Ghana'); INSERT INTO l10n VALUES ('GI', 'gibraltar', 'Gibraltar'); INSERT INTO l10n VALUES ('GL', 'greenland', 'Greenland'); INSERT INTO l10n VALUES ('GM', 'gambia_the', 'Gambia'); INSERT INTO l10n VALUES ('GN', 'guinea', 'Guinea'); INSERT INTO l10n VALUES ('GP', 'guadeloupe', 'Guadeloupe'); INSERT INTO l10n VALUES ('GQ', 'equatorial_guinea', 'Equatorial Guinea'); INSERT INTO l10n VALUES ('GR', 'greece', 'Greece'); INSERT INTO l10n VALUES ('GS', 'south_georgia_and_the_south_sandwich_islands', 'S. Georgia and S. Sandwich Isls.'); INSERT INTO l10n VALUES ('GT', 'guatemala', 'Guatemala'); INSERT INTO l10n VALUES ('GU', 'guam', 'Guam'); INSERT INTO l10n VALUES ('GW', 'guineabissau', 'Guinea-Bissau'); INSERT INTO l10n VALUES ('GY', 'guyana', 'Guyana'); INSERT INTO l10n VALUES ('HK', 'hong_kong', 'Hong Kong'); INSERT INTO l10n VALUES ('HM', 'heard_island_and_mcdonald_islands', 'Heard and McDonald Islands'); INSERT INTO l10n VALUES ('HN', 'honduras', 'Honduras'); INSERT INTO l10n VALUES ('HR', 'croatia', 'Croatia (Hrvatska)'); INSERT INTO l10n VALUES ('HT', 'haiti', 'Haiti'); INSERT INTO l10n VALUES ('HU', 'hungary', 'Hungary'); INSERT INTO l10n VALUES ('ID', 'indonesia', 'Indonesia'); INSERT INTO l10n VALUES ('IE', 'ireland', 'Ireland'); INSERT INTO l10n VALUES ('IL', 'israel', 'Israel'); INSERT INTO l10n VALUES ('IM', 'united_kingdom', 'Isle of Man'); INSERT INTO l10n VALUES ('IN', 'india', 'India'); INSERT INTO l10n VALUES ('IO', 'british_indian_ocean_territory', 'British Indian Ocean Territory'); INSERT INTO l10n VALUES ('IQ', 'iraq', 'Iraq'); INSERT INTO l10n VALUES ('IR', 'iran', 'Iran'); INSERT INTO l10n VALUES ('IS', 'iceland', 'Iceland'); INSERT INTO l10n VALUES ('IT', 'italy', 'Italy'); INSERT INTO l10n VALUES ('JE', 'united_kingdom', 'Jersey'); INSERT INTO l10n VALUES ('JM', 'jamaica', 'Jamaica'); INSERT INTO l10n VALUES ('JO', 'jordan', 'Jordan'); INSERT INTO l10n VALUES ('JP', 'japan', 'Japan'); INSERT INTO l10n VALUES ('KE', 'kenya', 'Kenya'); INSERT INTO l10n VALUES ('KG', 'kyrgyzstan', 'Kyrgyzstan'); INSERT INTO l10n VALUES ('KH', 'cambodia', 'Cambodia'); INSERT INTO l10n VALUES ('KI', 'kiribati', 'Kiribati'); INSERT INTO l10n VALUES ('KM', 'comoros', 'Comoros'); INSERT INTO l10n VALUES ('KN', 'saint_kitts_and_nevis', 'Saint Kitts and Nevis'); INSERT INTO l10n VALUES ('KP', 'korea_north', 'Korea (North)'); INSERT INTO l10n VALUES ('KR', 'korea_south', 'Korea (South)'); INSERT INTO l10n VALUES ('KW', 'kuwait', 'Kuwait'); INSERT INTO l10n VALUES ('KY', 'cayman_islands', 'Cayman Islands'); INSERT INTO l10n VALUES ('KZ', 'kazakhstan', 'Kazakhstan'); INSERT INTO l10n VALUES ('LA', 'laos', 'Laos'); INSERT INTO l10n VALUES ('LB', 'lebanon', 'Lebanon'); INSERT INTO l10n VALUES ('LC', 'saint_lucia', 'Saint Lucia'); INSERT INTO l10n VALUES ('LI', 'liechtenstein', 'Liechtenstein'); INSERT INTO l10n VALUES ('LK', 'sri_lanka', 'Sri Lanka'); INSERT INTO l10n VALUES ('LR', 'liberia', 'Liberia'); INSERT INTO l10n VALUES ('LS', 'lesotho', 'Lesotho'); INSERT INTO l10n VALUES ('LT', 'lithuania', 'Lithuania'); INSERT INTO l10n VALUES ('LU', 'luxembourg', 'Luxembourg'); INSERT INTO l10n VALUES ('LV', 'latvia', 'Latvia'); INSERT INTO l10n VALUES ('LY', 'libya', 'Libya'); INSERT INTO l10n VALUES ('MA', 'morocco', 'Morocco'); INSERT INTO l10n VALUES ('MC', 'monaco', 'Monaco'); INSERT INTO l10n VALUES ('MD', 'moldova', 'Moldova'); INSERT INTO l10n VALUES ('ME', 'montenegro', 'Montenegro'); INSERT INTO l10n VALUES ('MF', 'saint_martin', 'Saint Martin'); INSERT INTO l10n VALUES ('MG', 'madagascar', 'Madagascar'); INSERT INTO l10n VALUES ('MH', 'marshall_islands', 'Marshall Islands'); INSERT INTO l10n VALUES ('MK', 'macedonia_the_former_yugoslav_republic_of', 'F.Y.R.O.M. (Macedonia)'); INSERT INTO l10n VALUES ('ML', 'mali', 'Mali'); INSERT INTO l10n VALUES ('MM', 'burma', 'Myanmar'); INSERT INTO l10n VALUES ('MN', 'mongolia', 'Mongolia'); INSERT INTO l10n VALUES ('MO', 'macau', 'Macau'); INSERT INTO l10n VALUES ('MP', 'northern_mariana_islands', 'Northern Mariana Islands'); INSERT INTO l10n VALUES ('MQ', 'martinique', 'Martinique'); INSERT INTO l10n VALUES ('MR', 'mauritania', 'Mauritania'); INSERT INTO l10n VALUES ('MS', 'montserrat', 'Montserrat'); INSERT INTO l10n VALUES ('MT', 'malta', 'Malta'); INSERT INTO l10n VALUES ('MU', 'mauritius', 'Mauritius'); INSERT INTO l10n VALUES ('MV', 'maldives', 'Maldives'); INSERT INTO l10n VALUES ('MW', 'malawi', 'Malawi'); INSERT INTO l10n VALUES ('MX', 'mexico', 'Mexico'); INSERT INTO l10n VALUES ('MY', 'malaysia', 'Malaysia'); INSERT INTO l10n VALUES ('MZ', 'mozambique', 'Mozambique'); INSERT INTO l10n VALUES ('NA', 'namibia', 'Namibia'); INSERT INTO l10n VALUES ('NC', 'new_caledonia', 'New Caledonia'); INSERT INTO l10n VALUES ('NE', 'niger', 'Niger'); INSERT INTO l10n VALUES ('NF', 'norfolk_island', 'Norfolk Island'); INSERT INTO l10n VALUES ('NG', 'nigeria', 'Nigeria'); INSERT INTO l10n VALUES ('NI', 'nicaragua', 'Nicaragua'); INSERT INTO l10n VALUES ('NL', 'netherlands', 'Netherlands'); INSERT INTO l10n VALUES ('NO', 'norway', 'Norway'); INSERT INTO l10n VALUES ('NP', 'nepal', 'Nepal'); INSERT INTO l10n VALUES ('NR', 'nauru', 'Nauru'); INSERT INTO l10n VALUES ('NT', 'kuwait', 'Neutral Zone'); INSERT INTO l10n VALUES ('NU', 'niue', 'Niue'); INSERT INTO l10n VALUES ('NZ', 'new_zealand', 'New Zealand (Aotearoa)'); INSERT INTO l10n VALUES ('OM', 'oman', 'Oman'); INSERT INTO l10n VALUES ('PA', 'panama', 'Panama'); INSERT INTO l10n VALUES ('PE', 'peru', 'Peru'); INSERT INTO l10n VALUES ('PF', 'french_polynesia', 'French Polynesia'); INSERT INTO l10n VALUES ('PG', 'papua_new_guinea', 'Papua New Guinea'); INSERT INTO l10n VALUES ('PH', 'philippines', 'Philippines'); INSERT INTO l10n VALUES ('PK', 'pakistan', 'Pakistan'); INSERT INTO l10n VALUES ('PL', 'poland', 'Poland'); INSERT INTO l10n VALUES ('PM', 'saint_pierre_and_miquelon', 'St. Pierre and Miquelon'); INSERT INTO l10n VALUES ('PN', 'pitcairn_islands', 'Pitcairn'); INSERT INTO l10n VALUES ('PR', 'puerto_rico', 'Puerto Rico'); INSERT INTO l10n VALUES ('PS', 'west_bank', 'Palestinian Territory, Occupied'); INSERT INTO l10n VALUES ('PT', 'portugal', 'Portugal'); INSERT INTO l10n VALUES ('PW', 'palau', 'Palau'); INSERT INTO l10n VALUES ('PY', 'paraguay', 'Paraguay'); INSERT INTO l10n VALUES ('QA', 'qatar', 'Qatar'); INSERT INTO l10n VALUES ('RE', 'reunion', 'Reunion'); INSERT INTO l10n VALUES ('RS', 'serbia', 'Serbia'); INSERT INTO l10n VALUES ('RO', 'romania', 'Romania'); INSERT INTO l10n VALUES ('RU', 'russia', 'Russian Federation'); INSERT INTO l10n VALUES ('RW', 'rwanda', 'Rwanda'); INSERT INTO l10n VALUES ('SA', 'saudi_arabia', 'Saudi Arabia'); INSERT INTO l10n VALUES ('SB', 'solomon_islands', 'Solomon Islands'); INSERT INTO l10n VALUES ('SC', 'seychelles', 'Seychelles'); INSERT INTO l10n VALUES ('SD', 'sudan', 'Sudan'); INSERT INTO l10n VALUES ('SE', 'sweden', 'Sweden'); INSERT INTO l10n VALUES ('SG', 'singapore', 'Singapore'); INSERT INTO l10n VALUES ('SH', 'saint_helena', 'St. Helena'); INSERT INTO l10n VALUES ('SI', 'slovenia', 'Slovenia'); INSERT INTO l10n VALUES ('SJ', 'svalbard', 'Svalbard & Jan Mayen Islands'); INSERT INTO l10n VALUES ('SK', 'slovakia', 'Slovak Republic'); INSERT INTO l10n VALUES ('SL', 'sierra_leone', 'Sierra Leone'); INSERT INTO l10n VALUES ('SM', 'italy', 'San Marino'); INSERT INTO l10n VALUES ('SN', 'senegal', 'Senegal'); INSERT INTO l10n VALUES ('SO', 'somalia', 'Somalia'); INSERT INTO l10n VALUES ('SR', 'suriname', 'Suriname'); INSERT INTO l10n VALUES ('ST', 'sao_tome_and_principe', 'Sao Tome and Principe'); INSERT INTO l10n VALUES ('SU', 'soviet_union_former', 'USSR (former)'); INSERT INTO l10n VALUES ('SV', 'el_salvador', 'El Salvador'); INSERT INTO l10n VALUES ('SY', 'syria', 'Syria'); INSERT INTO l10n VALUES ('SZ', 'swaziland', 'Swaziland'); INSERT INTO l10n VALUES ('TC', 'turks_and_caicos_islands', 'Turks and Caicos Islands'); INSERT INTO l10n VALUES ('TD', 'chad', 'Chad'); INSERT INTO l10n VALUES ('TF', 'french_southern_and_antarctic_lands', 'French Southern Territories'); INSERT INTO l10n VALUES ('TG', 'togo', 'Togo'); INSERT INTO l10n VALUES ('TH', 'thailand', 'Thailand'); INSERT INTO l10n VALUES ('TJ', 'tajikistan', 'Tajikistan'); INSERT INTO l10n VALUES ('TK', 'tokelau', 'Tokelau'); INSERT INTO l10n VALUES ('TM', 'turkmenistan', 'Turkmenistan'); INSERT INTO l10n VALUES ('TN', 'tunisia', 'Tunisia'); INSERT INTO l10n VALUES ('TO', 'tonga', 'Tonga'); INSERT INTO l10n VALUES ('TP', 'east_timor', 'East Timor'); INSERT INTO l10n VALUES ('TR', 'turkey', 'Turkey'); INSERT INTO l10n VALUES ('TT', 'trinidad_and_tobago', 'Trinidad and Tobago'); INSERT INTO l10n VALUES ('TV', 'tuvalu', 'Tuvalu'); INSERT INTO l10n VALUES ('TW', 'taiwan', 'Taiwan'); INSERT INTO l10n VALUES ('TZ', 'tanzania', 'Tanzania'); INSERT INTO l10n VALUES ('UA', 'ukraine', 'Ukraine'); INSERT INTO l10n VALUES ('UG', 'uganda', 'Uganda'); INSERT INTO l10n VALUES ('UK', 'united_kingdom', 'United Kingdom'); INSERT INTO l10n VALUES ('UM', 'united_states', 'US Minor Outlying Islands'); INSERT INTO l10n VALUES ('US', 'united_states', 'United States'); INSERT INTO l10n VALUES ('UY', 'uruguay', 'Uruguay'); INSERT INTO l10n VALUES ('UZ', 'uzbekistan', 'Uzbekistan'); INSERT INTO l10n VALUES ('VA', 'holy_see_', 'Vatican City State (Holy See)'); INSERT INTO l10n VALUES ('VC', 'saint_vincent_and_the_grenadines', 'Saint Vincent & the Grenadines'); INSERT INTO l10n VALUES ('VE', 'venezuela', 'Venezuela'); INSERT INTO l10n VALUES ('VG', 'british_virgin_islands', 'British Virgin Islands '); INSERT INTO l10n VALUES ('VI', 'virgin_islands', 'Virgin Islands (U.S.)'); INSERT INTO l10n VALUES ('VN', 'vietnam', 'Viet Nam'); INSERT INTO l10n VALUES ('VU', 'vanuatu', 'Vanuatu'); INSERT INTO l10n VALUES ('WF', 'wallis_and_futuna', 'Wallis and Futuna Islands'); INSERT INTO l10n VALUES ('WS', 'samoa', 'Samoa'); INSERT INTO l10n VALUES ('XK', 'kosovo', 'Kosovo'); INSERT INTO l10n VALUES ('YE', 'yemen', 'Yemen'); INSERT INTO l10n VALUES ('YT', 'france', 'Mayotte'); INSERT INTO l10n VALUES ('YU', 'yugoslavia_former', 'Serbia and Montenegro (former Yugoslavia)'); INSERT INTO l10n VALUES ('ZA', 'south_africa', 'South Africa'); INSERT INTO l10n VALUES ('ZM', 'zambia', 'Zambia'); INSERT INTO l10n VALUES ('ZR', 'congo_democratic_republic_of_the', 'Democratic Republic of the Congo (former Zaire)'); INSERT INTO l10n VALUES ('ZW', 'zimbabwe', 'Zimbabwe');
You need to login to post a comment.
