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

[spaetz]

On Tue, Sep 02, 2008 at 12:45:02PM +0200, Florian Lohoff wrote:
> On Tue, Sep 02, 2008 at 12:09:51PM +0200, Martijn van Oosterhout wrote:
> > On Tue, Sep 2, 2008 at 10:52 AM, Florian Lohoff <flo at rfc822.org> wrote:
> > > The (un)escaping of UTF-8 characters still doesnt work and i have
> > > no clue how this works so need help here ... xmllint complains about
> > > the resulting osm files with >128 ascii chars are in there - And most likely
> > > some &>< escaping might be missing.
> > 
> > Half the point of UTF-8 is that you don't need to escape anything. As
> > long as you spit out exactly what was in the OSM data you should be
> > fine.
> 
> Okay - playing around with the mysql_enable_utf8 option wouldnt help -
> but a do("set names utf8") before issueing querys helps a lot :)

I think you can set that one time when creating the database:

CREATE DATABASE db_name
    CHARACTER SET utf8
    COLLATE utf8_general_ci

and perhaps in the table

CREATE TABLE `api05_node` (
  ...
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

and be done with it