Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 5D6C664FF27 for ; Fri, 5 Sep 2008 13:13:26 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 62861-02 for ; Fri, 5 Sep 2008 13:13:17 -0300 (ADT) X-Greylist: delayed 00:26:46.032163 by SQLgrey-1.7.6 Received: from vgateway.libertyrms.info (vgateway.libertyrms.info [207.219.45.62]) by postgresql.org (Postfix) with ESMTP id 5056964FD1A for ; Fri, 5 Sep 2008 13:13:17 -0300 (ADT) Received: from dba5.int.libertyrms.com ([10.1.3.44]) by vgateway.libertyrms.info with esmtp (Exim 4.22) id 1KbdW0-0008VL-Li for pgsql-admin@postgresql.org; Fri, 05 Sep 2008 11:46:28 -0400 Subject: Converting a Database from SQL_ASCII to UTF8 From: Brad Nicholson To: pgsql-admin@postgresql.org Content-Type: text/plain; charset=UTF-8 Date: Fri, 05 Sep 2008 11:46:28 -0400 Message-Id: <1220629588.6179.202.camel@bnicholson-desktop> Mime-Version: 1.0 X-Mailer: Evolution 2.22.3.1 Content-Transfer-Encoding: quoted-printable X-SA-Exim-Mail-From: bnichols@ca.afilias.info X-SA-Exim-Scanned: No; SAEximRunCond expanded to false X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200809/45 X-Sequence-Number: 30138 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. --=20 =EF=BB=BFBrad Nicholson 416-673-4106 Database Administrator, Afilias Canada Corp.