Re: Problem with special character - Mailing list pgsql-general

From Ragnar Hafstað
Subject Re: Problem with special character
Date
Msg-id 1110837798.26975.19.camel@localhost.localdomain
Whole thread Raw
In response to Problem with special character (ÿ) on postgresql 7.4... getting out of idea .. please help :-)  (David Gagnon <dgagnon@siunik.com>)
Responses Re: Problem with special character � on  (David Gagnon <dgagnon@siunik.com>)
List pgsql-general
On Mon, 2005-03-14 at 16:32 -0500, David Gagnon wrote:
> Hi,
>
> I really have a problem with a production environment (RH 9, Postgresql
> 7.4).

> When I deploy on the production env the same stored procedure with the
> same data (different OS and postgresql instance) the stored procedure
> crash. I get this error:
> java.io.IOException: Unable to get row: ERROR: cannot EXECUTE a null
> querystring when executing the
>
> I looked with pgadminIII and found that a charater used as a string
> separator (i.e.: ÿ) is shown as � on the production database. It look
> just oki in my dev env. (I included part of both stored procedure below).


were the 2 clusters initialized with the same locale
settings ?

gnari




pgsql-general by date:

Previous
From: David Gagnon
Date:
Subject: Problem with special character (ÿ) on postgresql 7.4... getting out of idea .. please help :-)
Next
From: jao@geophile.com
Date:
Subject: Logging VACUUM activity