[OSM-dev] Importing planet.osm into api0.5 db?

Tom Hughes tom at compton.nu
Thu Oct 4 11:27:06 BST 2007

In message <4704BBDD.2060105 at siliconcircus.com>
        Jon Bright <jon at siliconcircus.com> wrote:

> Brett Henderson wrote:
>> What happens if you type "status"?  Do you get utf8 in all the
>> characterset fields?
> Hm, no:
> Server characterset:    latin1
> Db     characterset:    latin1
> Client characterset:    latin1
> Conn.  characterset:    latin1
> Independent of this, shouldn't the migrations have made the tables
> UTF-8 anyway?  (I've cc-ed Tom, who seems to be the most likely
> person to know this...)

No, the database should have been created with UTF-8 as the default
character set. I thought db/README specified that, but it doesn't look
like it does so I have changed it.


Tom Hughes (tom at compton.nu)

More information about the dev mailing list