pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Hannes Dorbath <light@theendofthetunnel.de>
To: pgsql-admin@postgresql.org
Subject: Re: character problem
Date: Mon, 10 Oct 2005 09:28:18 +0200
Message-ID: <did562$epf$1@news.hub.org> (raw)
In-Reply-To: <4349106C.6080206@infinito.it>
References: <4349106C.6080206@infinito.it>

> like "èòéàùì", the string is stored in the database with other characters instead of those digited by the user.

Well, how does `èòéàùì' look like in your database? Like `èòéà ùì'? 
In that case you most probably have initialized your cluster with an 
UTF-8 locale while not using a / the correct client encoding.

You can check your database encoding with \l in psql.

If your perl clients don't handle UTF-8, just set a client encoding for 
them.

SET client_encoding = LATIN1;

for example.

The client encoding can be set for a user, as default in 
postgresql.conf, interactive using the command above and maybe other ways.

> And most important, is it possible to adjust the already inserted strings without having to update the tables?

Your first need to deside what is wrong at all -- the way the servers 
stores your chars, or the way your client displays them.

> is it possible to change the locale settings thus the strings in the database are displayed rightly?

The client encoding can be set anytime, to change the cluster LOCALE or 
database encoding you need to initDB + dump and restore AFAIK.


-- 
Regards,
Hannes Dorbath



view thread (10+ messages)  latest in thread

Message-ID: <did562$epf$1@news.hub.org>
Permalink:  ../did562$epf$1@news.hub.org/
Also on:    postgresql.org/message-id/did562$epf$1@news.hub.org

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: light@theendofthetunnel.de
  Subject: Re: character problem
  In-Reply-To: <did562$epf$1@news.hub.org>
  References: <4349106C.6080206@infinito.it> <did562$epf$1@news.hub.org>

* 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