[OSM-dev] [OSM-talk] Latest planet.osm contains incorrect data

[SteveC]

* @ 07/12/06 01:02:39 PM pere at hungry.com wrote:
> [Steve Coast]
> >> I guess the intended behavior is to store UTF-8 in the database and
> >> export UTF-8 in the dump.  For that to work properly all the database
> >> entries with ISO-8859-1 will need to be converted.  It should be
> > 
> > Actually no, because the API deals things out correctly.
> 
> I'm a bit confused by this comment.  Do the database store the strings
> as UTF-8 or at least using some encoding and reportoare with the full
> Unicode/ISO-10646 reportoar?

Some of the columns are latin, some are UTF8. You can tell mysql to
transparently set the connection as UTF8 and it will collate UTF8 in to
latin-1 for you and back. This is what it's doing in the API.

(and I've stopped spamming the talk list with this)

have fun,

SteveC steve at asklater.com http://www.asklater.com/steve/