[OSM-dev] UTF-8 problem with API 0.5 planet.osm and osmosis 0.16

Tom Hughes tom at compton.nu
Sat Sep 22 11:33:59 BST 2007

In message <20070922093505.GB10893 at lochewe.mathy.remote.org>
          Frederik Ramm <frederik at remote.org> wrote:

> I suspect that it may just be my MySQL setup on the test server. What
> I did was:
> * use original planet file, import into MySQL with osmosis
> * run 0.5 migrations
> * run 0.5 planet generation script on resulting database
> Since the planet generation script has not changed as regards nodes,
> and since the migrations don't touch nodes either, I suspect that I
> must have set up MySQL in a way that somehow mangles the UTF-8
> characters on input. It has happened in the past, and I hope you will
> let me get away with it... it's going to be right when done on the
> main database which is properly set up.

You probably didn't make UTF-8 the default character set for the
database when you created it.


Tom Hughes (tom at compton.nu)

More information about the dev mailing list