[OSM-dev] Database Schema

Tom Hughes tom at compton.nu
Tue Jun 26 08:35:02 BST 2007

In message <4680B8AA.4090301 at sxpert.org>
        Raphaël Jacquot <sxpert at sxpert.org> wrote:

> D Tucny wrote:
>> On 23/06/07, Dan Karran <dan at karran.net> wrote:
>>> - latitude (double)
>>> - longitude (double)
>>> - language (varchar(2))
>> Quick point, surely language needs to be more than 2 chars?
> see the ISO639-2 language table here :
> http://www.loc.gov/standards/iso639-2/php/English_list.php
> looks like it needs 3 chars

That all rather depends on how precise we need to be... More
information on the ISO639 variants at:


Personally I would stick with IETF language tags:


That will need more than 2 characters though, especially if you
want to allow the -region form.


Tom Hughes (tom at compton.nu)

More information about the dev mailing list