Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 526829FA4B2
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 22 Dec 2006 19:13:02 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024)
	with ESMTP id 50869-06 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri, 22 Dec 2006 19:12:57 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.228])
	by postgresql.org (Postfix) with ESMTP id 32CE29FA48A
	for <pgsql-sql@postgresql.org>; Fri, 22 Dec 2006 19:12:57 -0400 (AST)
Received: by wx-out-0506.google.com with SMTP id i28so2913900wxd
	for <pgsql-sql@postgresql.org>; Fri, 22 Dec 2006 15:12:56 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:user-agent:mime-version:to:subject:content-type:content-transfer-encoding:sender;
	b=pev4xH8t5KPg5H5V1QpR864waLBQy9XTJGeG+N93E2LHXkZVg9S098TTQZ5ph85Uv9hy/4kw14BskSfATIdwR1Qu/ps7FIGurJsr2RUwUK8VxaLngwQgKI4gIN+Dqi8sq0ACvDpionLi4tLbFMvPBHK/+SjHP0Ue/76ZySmAK0s=
Received: by 10.70.47.19 with SMTP id u19mr17466035wxu.1166829175871;
	Fri, 22 Dec 2006 15:12:55 -0800 (PST)
Received: from ?82.48.119.172? ( [82.48.119.172])
	by mx.google.com with ESMTP id 39sm30867626wrl.2006.12.22.15.12.54;
	Fri, 22 Dec 2006 15:12:55 -0800 (PST)
Message-ID: <458C6650.80105@computer.org>
Date: Sat, 23 Dec 2006 00:12:16 +0100
From: Alexis Paul Bertolini <bertolini@computer.org>
User-Agent: Thunderbird 1.5.0.9 (Windows/20061207)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: Changing character set when the damage is done
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=BAYES_50, SPF_PASS
X-Spam-Level: 
X-Archive-Number: 200612/163
X-Sequence-Number: 27119

Dear all,

I set up a DB with default values and it now uses the SQL_ASCII 
character set (as per "show client_encoding;").

I have copied in quite a lot of data from various Access databases but 
only now have I realized that all accented vowels show up differently 
from what I expected (I dare not cite some examples a they would 
doubtlessly show up wrong in the mail).

The contents are text written in Italian, so it's just the 5 vowels with 
an acute or grave accent. The user base is all Italian, so a quick and 
dirty trick is perfectly viable.

Any chance of running some smart UPDATE queries to put things right? Or 
elaborating on the fields whilst performing a SELECT query?

Thanks!

Alex.