Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id DCD9E9FB750 for ; Thu, 22 Mar 2007 10:07:18 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 92714-03 for ; Thu, 22 Mar 2007 10:07:07 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.170]) by postgresql.org (Postfix) with ESMTP id 6B2C99FB71D for ; Thu, 22 Mar 2007 10:07:12 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id k3so641311ugf for ; Thu, 22 Mar 2007 06:07:10 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=giVQ3zGE/+A58TGIqLl/fl9gBKPPbdH1U38Y4sNkTz/t1AHzHwUdwPG2lQoPluSo1m9vCljwQ/Rg/cTXxjWeztB8Oaffd+N4NVIi8F8Y88TGB/MpSoO0NScJSRP9Zl7NFCgCN9FWl2W+A/w+sZsPVDRqy8aQAugUIr2VYGAiDhE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=UKSvZr1lmqxanwy/xZSbkKbNvyT+SOO3svHFdwFn/5BwWuRnBoO3Nh7k4Y1Nf9i4G0JTOaW1prM9JokpsL3CPmZY0rTd3n5j0fxmx8tINEjBHG4gyCKzHXBsngkZsUa2gNUVEIeKz+gNRQRojj5mHw7voDRNaOPDwgb1uZGBvWo= Received: by 10.115.14.1 with SMTP id r1mr592989wai.1174568829860; Thu, 22 Mar 2007 06:07:09 -0700 (PDT) Received: by 10.114.61.19 with HTTP; Thu, 22 Mar 2007 06:07:09 -0700 (PDT) Message-ID: <938bcd6f0703220607g1d099e45mb266f8cc4f085de5@mail.gmail.com> Date: Thu, 22 Mar 2007 13:07:09 +0000 From: "Bjarni Ragnarsson" To: pgsql-admin@postgresql.org Subject: Encoding problems MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200703/159 X-Sequence-Number: 24983 Hi everyone. I have some encoding problems like many others. I'm using Python (and Django) with my PostgreSQL 8.2 and pgAdmin 1.6.2 on Windows XP Pro. The default encoding here in Iceland is win1252. I have a database with that encoding. The problem is that pgAdmin seems to use utf8 no matter what I do. The data seems to be stored correctly when entered via a web-page, but when displayed via pgAdmin it's corrupted (that is the special characters don't show correctly). pgAdmin seems to presume the data is in utf8 format despite the database settings. Entering data via pgAdmin results in corrupted data on the web likewise. Is this a bug or is there some setting I've overlooked?