Thomas’ Developer Blog

June 27, 2008

ISO 639-3 Language Codes (XML Cheat Sheet)

Filed under: HTML, sql, xml — Tags: , , , , , , , — sanzon @ 5:22 am

For those who know anything about languages it can be a pain in the but trying to organize them.  I’m not talking about creating different langauges on your site. I’m simply talking about storing those ISO codes into a database so you can retrieve them later.

After a few hours of work I managed to thread through a pretty long list of codes and input them into a database for later use!

Now due to the size of the list and the pain of writing everything down I’m going to direct link you to a XML file. This XML file will make it far easier to update your database. Now I’m only go share this file. It is up to you to write the code to input it. Which isn’t hard for anyone who has some basic database knowledge along with asp.net’s ADO.net practices.

Anyway it is my great great hope that this will help you out a LOT.

I know a lot of sites, Veoh for example, use ISO 639-1. I feel that while you can get away with it, I prefer to be up to date. This XML file is for June of 2008 and the lastest update for ISO 639-3. Also I went ahead and combined a few of the duplicate codes together so you can input them as a unique code. If you run through it, it took me about 5 to 10 minutes on local host of waiting for it to all input.

You can find the XML file at:

http://www.2shared.com/file/3504750/bd97c19e/ISO639_3.html

Be sure to share it if possible. Since I know it’s a pain to find it online.

Advertisements

7 Comments »

  1. Hey I came across you site while looking for a plug-in for WordPress which would allow me to add an ISO 639-3 code to a custom field. I don’t know if you are talking here about harvesting the data from this page http://www.sil.org/ISO639-3/codes.asp

    or if you had seen this page: http://www.sil.org/ISO639-3/download.asp

    Comment by Hugh — February 16, 2009 @ 5:52 am

  2. I’ve been surfing online more than three hours today, yet I never found any interesting article like yours. It is pretty worth enough for me. In my view, if all website owners and bloggers made good content as you did, the internet will be a lot more useful than ever before.

    Comment by How to Play Candy crush saga — July 22, 2013 @ 7:53 am

  3. Hello there! This blog post couldn’t be written any better! Going through this post reminds me of my previous roommate! He always kept talking about this. I’ll
    forward this post to him. Pretty sure he’ll have a great read. Thank you for sharing!

    Comment by criminal case hints — August 20, 2013 @ 8:01 am

  4. I’m extremely impressed with your writing skills as well as with the layout on your weblog. Is this a paid theme or did you customize it yourself? Either way keep up the excellent quality writing, it’s
    rare to see a nice blog like this one these days.

    Comment by facebook games tricks — August 20, 2013 @ 9:18 pm

  5. Hey there! I just wanted to ask if you ever have any trouble with hackers?

    My last blog (wordpress) was hacked and I ended up losing many
    months of hard work due to no backup. Do you have any solutions to protect
    against hackers?

    Comment by marvel avengers alliance manual — August 22, 2013 @ 12:48 pm

  6. Ahaa, its fastidious dialogue regarding this piece of
    writing here at this webpage, I have read all that, so at this
    time me also commenting at this place.

    Comment by Into The Dead Cheats — September 27, 2013 @ 7:47 am

  7. Heya! I understand this is kind of off-topic but I had to ask.
    Does operating a well-established website such as yours require a large amount of
    work? I am brand new to operating a blog but I do write in my journal on a daily basis.
    I’d like to start a blog so I can share my
    experience and feelings online. Please let me know if you have any suggestions
    or tips for brand new aspiring blog owners. Appreciate it!

    Comment by how to configure best cable how to configure modem billion — August 15, 2014 @ 8:10 am


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: