Skip site navigation (1) Skip section navigation (2)

Encoding problems

From: "Bjarni Ragnarsson" <bjarnir(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Encoding problems
Date: 2007-03-22 13:07:09
Message-ID: 938bcd6f0703220607g1d099e45mb266f8cc4f085de5@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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?

Responses

pgsql-admin by date

Next:From: Bjarni RagnarssonDate: 2007-03-22 13:10:48
Subject: Accidental message
Previous:From: Sabin CoandaDate: 2007-03-22 12:35:37
Subject: set password doesn't work

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group