character problem - Mailing list pgsql-admin

From Luca Ferrari
Subject character problem
Date
Msg-id 4349106C.6080206@infinito.it
Whole thread Raw
Responses Re: character problem  (Hannes Dorbath <light@theendofthetunnel.de>)
List pgsql-admin
Hi,
I've got a postgres installation which is accessed by users thru a set
of perl CGIs. Unlickily, when the user enters some characters in a
description (string) field, like "èòéàùì", the string is stored in the
database with other characters instead of those digited by the user. It
seems as the locale setting of the client and of the server are
different, but in the postgresql.conf file I didn't find such setting.
My question is: how can I fix the problem? And most important, is it
possible to adjust the already inserted strings without having to update
the tables? I mean, is it possible to change the locale settings thus
the strings in the database are displayed rightly?

Thanks,
Luca
--
Luca Ferrari
fluca1978@infinito.it


pgsql-admin by date:

Previous
From: "Nirav Parikh"
Date:
Subject: pg_dump
Next
From: Luca Ferrari
Date:
Subject: Re: pg_dump