[Tilesathome] rendering arabic street/localities names

[Florian Lohoff]

On Tue, Sep 09, 2008 at 06:41:41PM +0200, Steven te Brinke wrote:
> Subject: Re: [Tilesathome] rendering arabic street/localities names
> 
> Probably you know already more about mysql and utf-8 than I do. But I 
> want to mention that in mysql you need to set the connection to utf-8 
> too. At least when I access my utf-8 tables from php, I'll get crap out 
> of it if I don't set the connection to utf-8 explicitly. Thus the 
> connection always defaults to a non utf-8 character set in my (the 
> default) setup.

I do that - Its not that ALL utf-8 characters get garbled but rather
osmosis failed to import them correctly. So in mysql they are already
garbled. I checked some russian utf-8 names and i didnt find a problem.
I looked at hebrew stuff as that was the broken tile i got told first
and most of the hebrew was broken in that bbox.

So i have no clue what the problem was/is but in the end i am going to
switch over to postgres as the map.cgi is MUCH simpler as most of the
stuff can be done nicely in sql syntax and in the end its faster too.

Flo
-- 
Florian Lohoff                  flo at rfc822.org             +49-171-2280134
	Those who would give up a little freedom to get a little 
          security shall soon have neither - Benjamin Franklin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
URL: <http://lists.openstreetmap.org/pipermail/tilesathome/attachments/20080909/de478d03/attachment.pgp>