Re: Problem with special character

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