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

From David Gagnon
Subject Re: Problem with special character � on
Date
Msg-id 42361110.6010200@siunik.com
Whole thread Raw
In response to Re: Problem with special character  (Ragnar Hafstað <gnari@simnet.is>)
Responses Re: Problem with special character � on
List pgsql-general
Thanks for your answer.

  The ISP created the db fom me .. So I don't have this information. I
search the web to know how to get this info via PgadminIII and I haven't
found :-(  Is there a way to get this information once the database have
been created ?  I looked via psql .. I haven`t found either

Thanks
/David

Ragnar Hafstað wrote:

>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: jao@geophile.com
Date:
Subject: Logging VACUUM activity
Next
From: Miroslav Šulc
Date:
Subject: Re: Problem with special character � on