Converting a Database from SQL_ASCII to UTF8

From: Brad Nicholson <bnichols(at)ca(dot)afilias(dot)info>
To: pgsql-admin(at)postgresql(dot)org
Subject: Converting a Database from SQL_ASCII to UTF8
Date: 2008-09-05 15:46:28
Message-ID: 1220629588.6179.202.camel@bnicholson-desktop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I'm looking at converting some databases from SQL_ASCII to UTF8. The
conversion worked fine in tests, so I'm not overly concerned about the
data. What I'm wondering is if there is from the client side I should
be worried about (ie - different query plans being chosen), or should it
be transparent to the application.
--
Brad Nicholson 416-673-4106
Database Administrator, Afilias Canada Corp.

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2008-09-05 16:52:17 Re: How can I avoid Frozenxid wraparound on failover to a standby(PITR) database?
Previous Message Tom Lane 2008-09-05 15:39:10 Re: change max_value in sequence