Behavior, Content, Money – 3 Things you should never give away for free!!!

BCmoney MobileTV

l10n Locales (HTML) select box and data (SQL)

Posted by bcmoney on March 1, 2010 in E-Commerce, HTML, Semantic Web, SQL, XML with 7 Comments

No Gravatar
English: World map colored according to statis...

Image via Wikipedia

L10N is an acronym that stands for Localization (coming from the 10 letters in between “L” and “N” in the word Localization). L10N is a combination of software and language targeted to a specific region’s (or more specifically – locale’s) dialect and/or socio-cultural, politically correct, visually appealing representation. The standards and specifications most commonly used to implement or develop support for L10N is ISO 3166.

While a complete list of locales is available on the ISO’s ISO-3166 website, there are no particularly easy-to-use versions of the data except for a zipped XML file. For convenience’s sake, we’re offering an L10N SQL script in an easy-to-use 2-column format, and an HTML select drop-down version below:
L10N code:   

Code available here:

SQL for the same set of l10n data is available below:
[snippet id=46094]
You can feel free to change or enhance ithe simple 3 column structure anyway you like.

Localization and Internationalization go together quite well, and the W3C recommends this combination through the use of hyphenated values of the form:
Where i18n is the 3-character Internationalization language code, and l10n is the 2-character country/region code. For instance, the French language as spoken in France specifically would be:
Whereas the French language in Canada would be:

Within country locales, you can subdivide the nation into regions in a similar fashion, for example, the unique French spoken in Quebec could be:
This however, is not standardized. You can check the Internationalization and Localization friendliness of your websites and applications using the W3C i18n Checker.

Internationalization and Localization of Web Applications is certainly a well-studied if not under-used approach to making web content accessible to the widest audience possible.

Localization in particular has many benefits and use-cases. For example, Google’s search engine made great strides in specific locales not yet penetrated by a definitive market leader in search after having their basic search form translated into many languages and dialects. By 2002, the Google basic search interface had been translated into 72 language & locale combinations, including Klingon. In general, you can access different language localizations using the hl parameter, for instance Japanese, Celtic, English (US) or English (UK). Furthermore, they have embedded auto-localization features in their Google Translate service, which has made it much more popular than competitors such as BabelFish, and encouraged more users with multiple language skills to contribute translations, thereby continually improving the quality of translations. Localization studies have even convinced Google Japan to adapt their infamously simple homepage with single search form and a few header links to something more akin to Yahoo! Japan’s busy portal landing page (which rarely enough still enjoys a massive lead over Google in the Japanese search market).


  1. money4lifeDecember 31, 2012 - 3:23 am #1

    I just planned to toss you a large cheers you fixed many items for me personally!

  2. K. RendelJanuary 14, 2013 - 12:33 pm #2

    I have to give you credit where credit is due, this is fairly useful for getting started with a clean database. Search through I see nothing but good blog posts, would love to increase the quality to have just like yours inside my site. Just how do I turn up the creativity and approach the quality of these kind of blogposts? All the best and keep posting!

  3. VenueFinderJanuary 19, 2013 - 12:11 am #3

    You might be one of the great unknown blogs, lucky I found you in my search results for L10N. My business partners and I usually do not ask for people to do link shares but if you are interested we’re a UK-based Venue Finder service. I don’t suppose you’d check it out?

    In any case, we used the localization data you supplied to populate our site’s DB. Thanks and we’ll be reading everything you post from here on!

  4. CameliaFebruary 6, 2013 - 1:50 am #4

    Incredible! Amazing step by step short training and short tutorials. I am all about E-Learning and plan to use your site more which will help me in my attempts to learn about web development!

  5. Keitha MarroneMarch 14, 2013 - 3:59 am #5

    Always enjoy the the great information you offer with these articles. Bookmarked!

  6. FoertschJune 4, 2013 - 4:04 am #6

    Knowing is the first step to doing… good to keep in mind and talk about localization more as its an often over-looked part of App development. Best Regards! Ciao

Leave a Reply

Posts with similar tags
Posts in similar categories

BC$ = Behavior, Content, Money

The goal of the BC$ project is to raise awareness and make changes with respect to the three pillars of information freedom - Behavior (pursuit of interests and passions), Content (sharing/exchanging ideas in various formats), Money (fairness and accessibility) - bringing to light the fact that:

1. We regularly hand over our browser histories, search histories and daily online activities to companies that want our money, or, to benefit from our use of their services with lucrative ad deals or sales of personal information.

2. We create and/or consume interesting content on their services, but we aren't adequately rewarded for our creative efforts or loyalty.

3. We pay money to be connected online (and possibly also over mobile), yet we lose both time and money by allowing companies to market to us with unsolicited advertisements, irrelevant product offers and unfairly structured service pricing plans.

  • Archives