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.
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