pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bjarni Ragnarsson <bjarnir@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Encoding problems
Date: Thu, 22 Mar 2007 13:07:09 +0000
Message-ID: <938bcd6f0703220607g1d099e45mb266f8cc4f085de5@mail.gmail.com> (raw)

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?



view thread (4+ messages)  latest in thread

Message-ID: <938bcd6f0703220607g1d099e45mb266f8cc4f085de5@mail.gmail.com>
Permalink:  ../938bcd6f0703220607g1d099e45mb266f8cc4f085de5@mail.gmail.com/
Also on:    postgresql.org/message-id/938bcd6f0703220607g1d099e45mb266f8cc4f085de5@mail.gmail.com

 · 

reply

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-admin@postgresql.org
  Cc: bjarnir@gmail.com
  Subject: Re: Encoding problems
  In-Reply-To: <938bcd6f0703220607g1d099e45mb266f8cc4f085de5@mail.gmail.com>

* 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