[Tilesathome] setting up the api was: [OSM-dev] t at h API still turn off...

[Martijn van Oosterhout]

On Tue, Sep 2, 2008 at 12:27 PM, Florian Lohoff <flo at rfc822.org> wrote:
>  <node id="50553449" lat="51.7439626" lon="8.3798345" user="seufer_wolle" visible="true" timestamp="2007-09-13T12:27:46+01:00">
>    <tag k="created_by" v="JOSM"/>
>    <tag k="name" v="Mastholte-Süd"/>
>    <tag k="is_in" v="Northrine-Westfalia,Germany"/>
>    <tag k="place" v="village"/>
>  </node>
>
> So some recoding is going on somewhere (i'll not exclude intelligent perl)

Don't forget things like:

binmode STDOUT, ":utf8";
binmode STDIN, "utf8";

And any filehandles you might be using. You must do this if you want
the output to be UTF-8 encoded. Otherwise it defaults to your locale.
I know it's painful but you need to make sure your input side handled
it properly, you need to check the actual bytes coming from the mysql
server, just SELECT stataments at the console won't do, because your
terminal will "guess" the encoding sometimes making it look like it
works when it's actually wrong.

Have a nice day,
-- 
Martijn van Oosterhout <kleptog at gmail.com> http://svana.org/kleptog/