X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B9D63D9A72 for ; Mon, 10 Oct 2005 03:33:24 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 60601-04 for ; Mon, 10 Oct 2005 06:33:22 +0000 (GMT) Received: from antivirus.unimo.it (antivirus.unimo.it [155.185.1.3]) by svr1.postgresql.org (Postfix) with ESMTP id 6E696D9A62 for ; Mon, 10 Oct 2005 03:33:21 -0300 (ADT) Received: from [155.185.48.190] (fluca.ing.unimo.it [155.185.48.190]) by antivirus.unimo.it (8.12.11/8.12.11) with ESMTP id j9A6XKnC012518 for ; Mon, 10 Oct 2005 08:33:20 +0200 Message-ID: <4349106C.6080206@infinito.it> Date: Sun, 09 Oct 2005 14:43:24 +0200 From: Luca Ferrari User-Agent: Mozilla Thunderbird 1.0.6 (Windows/20050716) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: character problem Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-milter on antivirus (http://amavis.org/) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.516 required=5 tests=[FROM_ENDS_IN_NUMS=0.516] X-Spam-Level: X-Archive-Number: 200510/99 X-Sequence-Number: 19171 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