public inbox for [email protected]  

help / color / mirror / Atom feed

From: Tom Lane <[email protected]>
To: Jason McManus <[email protected]>
Cc: [email protected]
Subject: Re: Notes on converting from MySQL 5.0.x to PostgreSQL 8.1.4
Date: Fri, 30 Jun 2006 10:17:10 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

"Jason McManus" <[email protected]> writes:
> I am in the process of converting a couple of major sites from MySQL 5.0.22
> to PostgreSQL 8.1.4, and I thought I would share some of my observations on
> this process and the two database systems in general.

Nice notes!  I see only one small error:

> * Pg's default character set (in 8.1.4) is UTF8.

I don't believe there is any fixed "default character set".  Each
installation will have a default locale and encoding, but these depend
on the locale under which initdb was run.  From the above comment I
surmise that you initdb'd under some UTF8-using locale ...

> Thank you, and I hope that these notes prove helpful to others!

Perhaps they should go on the project website somewhere?

			regards, tom lane

view thread (38+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Notes on converting from MySQL 5.0.x to PostgreSQL 8.1.4
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox