Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id D08F09F9F46 for ; Sun, 24 Dec 2006 12:05:45 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 52745-01 for ; Sun, 24 Dec 2006 12:05:40 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.184]) by postgresql.org (Postfix) with ESMTP id F0CD99FA28E for ; Sun, 24 Dec 2006 12:05:39 -0400 (AST) Received: by nf-out-0910.google.com with SMTP id x4so4309105nfb for ; Sun, 24 Dec 2006 08:05:38 -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:references:in-reply-to:content-type:content-transfer-encoding:sender; b=lCvao4oT55uFoYfxZ4viouNjwUh5Wix42ua6ZBI62X2zth+B2+SCEJ5ooTLdIUEzy3IvE2dydxohZpSkMnCVj4Chq56S+m2bPqvLjAEGSEAmAnymmiTGaIqGN0zjhy8lO72DrYS1dczHEAdFKK/UXD9QxUhZhVqi2GgtMuetoHc= Received: by 10.49.75.2 with SMTP id c2mr2750481nfl.1166976338514; Sun, 24 Dec 2006 08:05:38 -0800 (PST) Received: from ?82.54.155.138? ( [82.54.155.138]) by mx.google.com with ESMTP id x24sm52171426nfb.2006.12.24.08.05.37; Sun, 24 Dec 2006 08:05:38 -0800 (PST) Message-ID: <458EA551.3090008@computer.org> Date: Sun, 24 Dec 2006 17:05:37 +0100 From: Alexis Paul Bertolini User-Agent: Thunderbird 1.5.0.9 (Windows/20061207) MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: Changing character set when the damage is done References: <458C6650.80105@computer.org> <1166831523.6369.308.camel@localhost.localdomain> In-Reply-To: <1166831523.6369.308.camel@localhost.localdomain> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/165 X-Sequence-Number: 27121 Ragnar wrote: > On lau, 2006-12-23 at 00:12 +0100, Alexis Paul Bertolini wrote: > > depends on whether all imports have been in the same encoding > or not. SQL_ASCII basically accepts and stores the characters > without interpretation, so if all imorts were done with one > client_encoding, you should be able to read the values again > using the same encoding. > > are all the instances of these 5 characters the same everywhere? > in that case there is a good chance that you can fix the values > with UPDATES > > when you say > 'all accented vowels show up differently from what I expected' > do you mean in psql or some other tool? > do these show as 1 or 2 characters? Thanks for your reply, Gnari, all imports were done using default values, so the encoding ought to be the same. As proof of this, same characters show up in the same way. They show up in PHP, PgAdminIII and psql. All the same. A lowercase e with a grave accent appears as a capital A with the cedilla, followed by an umlaut (just the umlaut, on its own). So to answer your question, they are two characters. Oh... and Merry Christmas! Alex.