From: Alexis Paul Bertolini <bertolini@computer.org>
To: pgsql-sql@postgresql.org
Subject: Changing character set when the damage is done
Date: Sat, 23 Dec 2006 00:12:16 +0100
Message-ID: <458C6650.80105@computer.org> (raw)
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.
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: pgsql-sql@postgresql.org
Cc: bertolini@computer.org
Subject: Re: Changing character set when the damage is done
In-Reply-To: <458C6650.80105@computer.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox