Re: Problems with JDBC client and LATIN1 chars - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Problems with JDBC client and LATIN1 chars
Date
Msg-id Pine.BSO.4.56.0403091902390.32046@leary.csoft.net
Whole thread Raw
In response to Problems with JDBC client and LATIN1 chars  (kenr@redergaard-it.no)
List pgsql-jdbc

On Thu, 4 Mar 2004 kenr@redergaard-it.no wrote:

> Hi,
>
> I'm experiencing a decoding problem with PG 7.3.4 and the latest
> Postgresql JDBC driver.
>
> When transfering the Norwegian letters øæå the JDBC driver claims that
> illegal chars are received. But when using pgAdmin this works fine.
>
> Are there any patches available to get pgAdmin behaviour (accepting LATIN1) ?

pgAdmin is one of the many pg clients that are in the "ignorance is bliss"
category.  Java needs your encoding to be correct.

> Or do I have to pgdump, stop the production environment, alter the cluster
> to use LATIN1, and pgrestore the db ? I really hope that there is another
> way to do this...
>

Sorry, no.

Kris Jurka


pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: About use SSL by JDBC
Next
From: "David Wall"
Date:
Subject: Re: Using auto-commit OFF for transactions - instead of BEGIN