From: Ivo Rossacher <rossacher@bluewin.ch>
To: pgsql-admin@postgresql.org
Subject: Re: Encoding problems
Date: Thu, 22 Mar 2007 20:00:59 +0100
Message-ID: <200703222000.59688.rossacher@bluewin.ch> (raw)
In-Reply-To: <938bcd6f0703220607g1d099e45mb266f8cc4f085de5@mail.gmail.com>
References: <938bcd6f0703220607g1d099e45mb266f8cc4f085de5@mail.gmail.com>
show client_encoding displays the encoding to which the server currently is
converting. With set client_encoding to UNICODE; you can change the
client_encoding on the fly and check if the results becomes better. I am not
sure how to adjust the client_encoding in pgAdmin so that this will be set at
startup automtically. There is a default client_encoding stored in the server
as well but there you have to check if it interfers with your other
interfaces.
Best regards
Ivo
Am Donnerstag, 22. März 2007 14:07 schrieb Bjarni Ragnarsson:
> 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?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
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: rossacher@bluewin.ch
Subject: Re: Encoding problems
In-Reply-To: <200703222000.59688.rossacher@bluewin.ch>
* 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