[OSM-dev] Database Schema

[Tom Hughes]

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:

  http://en.wikipedia.org/wiki/ISO_639

Personally I would stick with IETF language tags:

  http://en.wikipedia.org/wiki/IETF_language_tag
  http://tools.ietf.org/html/rfc4646

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

Tom

-- 
Tom Hughes (tom at compton.nu)
http://www.compton.nu/