[OSM-dev] OSM Mapnik Fonts are Nonsense

Jon Burgess jburgess777 at gmail.com
Tue Nov 2 22:44:35 GMT 2010


On Tue, 2010-11-02 at 23:26 +0100, Peter Körner wrote:
> 
> Am 02.11.2010 22:35, schrieb Jon Burgess:
> > On Tue, 2010-11-02 at 21:14 +0000, maw269 at gmail.com wrote:
> >> All the letters in Eastern Europe, Asia, the Middle East, North Africa
> >> and similar areas that don't use the english alphabet, are nonsense.
> >> See http://d.imagehost.org/0402/OSM.png
> >>
> >> Can someone please help me?
> >
> > That looks quite broken but I'm not convinced the issue is with Mapnik
> > itself. Are you sure that the data was imported into postgres using a
> > UTF8 database?
> 
> This is not necessary. On ptolemy, the wikimedia toolserver I missed to 
> create the table as UTF8 and we have multilingual rendering nevertheless:
> 
> http://toolserver.org/~osm/locale/?locale=ar
> http://toolserver.org/~osm/locale/?locale=zh
> http://toolserver.org/~osm/locale/?locale=el
> http://toolserver.org/~osm/locale/?locale=ru
> 
> 
> mazder at ptolemy:~$ psql -h sql-mapnik -d osm_mapnik
> Welcome to psql 8.3.11, the PostgreSQL interactive terminal.
> 
> Type:  \copyright for distribution terms
>         \h for help with SQL commands
>         \? for help with psql commands
>         \g or terminate with semicolon to execute query
>         \q to quit
> 
> osm_mapnik=> \l
>           List of databases
>      Name    |  Owner   | Encoding
> ------------+----------+-----------
>   osm_api    | osm      | SQL_ASCII
>   osm_mapnik | osm      | SQL_ASCII
>   postgres   | postgres | SQL_ASCII
>   template0  | postgres | SQL_ASCII
>   template1  | postgres | SQL_ASCII
>   u_kolossos | kolossos | SQL_ASCII
> (6 rows)

Have you tried any other settings? I suspect that many other common
encodings will not work so well (LATIN1, WIN1252 etc). We know UTF8
works and that is what we recommend everyone should use.

  Jon






More information about the dev mailing list