unicode troubles and postgres [SOLVED]

[Chris Angelico]

On Fri, Jan 10, 2014 at 6:51 AM, Ethan Furman <ethan at stoneleaf.us> wrote:
> The problem was I had created the database from template0 instead of
> template1, and 0 is SQL-ASCII while 1 is UTF8.

Ah, this is one of the traps with Postgres. This is one of the reasons
I prefer not to touch template[01] and to script the initialization of
a new database - any config changes are committed to source control as
part of that script.

ChrisA