| From: | Ragnar Hafstað <gnari(at)simnet(dot)is> |
|---|---|
| To: | David Gagnon <dgagnon(at)siunik(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Problem with special character |
| Date: | 2005-03-14 22:03:18 |
| Message-ID: | 1110837798.26975.19.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | jao | 2005-03-14 22:12:26 | Logging VACUUM activity |
| Previous Message | David Gagnon | 2005-03-14 21:32:38 | Problem with special character (ÿ) on postgresql 7.4... getting out of idea .. please help :-) |