[Openstreetmap-dev] Re: [Openstreetmap] Map views off line?

Erik Johansson erjohan at gmail.com
Tue Dec 27 00:24:21 GMT 2005


On 12/25/05, Johnny Doe <uucp1 at yahoo.com> wrote:
>
>
> --- Mikel Maron <mikel_maron at yahoo.com> wrote:
> >
> > The GNS database only contains ascii.
>
> The GNS description says:
> Download Complete Files of Geographic Names for
> Geopolitical Areas from GNS ( ISO/IEC 10646 [Unicode
> UTF-8] Compliant as of 18 July 2002 )

Yes they are unicode, see
http://earth-info.nga.mil/gns/html/gis.html for more information on
these fields, it works when requesting on an UTF-8 terminal.

select SORT_NAME,FULL_NAME,FULL_NAME_ND from GEO where full_name = 'Gävle';
+-----------+-----------+--------------+
| SORT_NAME | FULL_NAME | FULL_NAME_ND |
+-----------+-----------+--------------+
| GAVLE     | Gävle    | Gavle        |
| GAVLE     | Gävle    | Gavle        |
| GAVLE     | Gävle    | Gavle        |
+-----------+-----------+--------------+
3 rows in set (0.71 sec)




More information about the dev mailing list