Re: Accents bug ? - Mailing list pgsql-jdbc

From Denis Bucher
Subject Re: Accents bug ?
Date
Msg-id 5.1.0.14.0.20011002120708.0242fa90@mail.niftycom.com
Whole thread Raw
In response to Re: Accents bug ?  (Rene Pijlman <rene@lab.applinet.nl>)
Responses Re: Accents bug ?  (Knut Forkalsrud <kforkalsrud@cj.com>)
List pgsql-jdbc
At 11:48 02.10.01 +0200, Rene Pijlman wrote:

Hello !

> >It sounds like an encoding problem. You can check the encoding of the db
> >by using \encoding in psql.
> >There is a section in the docs on this
> >http://www.postgresql.org/idocs/index.php?multibyte.html
>
>And more on
>http://lab.applinet.nl/postgresql-jdbc/#CharacterEncoding

Yes, very interesting, it says :
jdbc:postgresql://localhost/dbname?charSet=UTF-8&user=foo&password=bar

But it gives me an error using that connection string :
 >
jdbc:postgresql://sashimi:5432/ekai?charSet=UNICODE&user=ekaitest&password=aaa

...when doing my executeQuery I get :
 > VendorError:  0
 > SQLState:     null
 > SQLException: postgresql.con.encoding

So, not better... or is it really "UNICODE" ?

>I've heard of conversion problems before, but not of chunking
>the data though.

Yes, that's the most strange I think :-)

Denis


pgsql-jdbc by date:

Previous
From: Rene Pijlman
Date:
Subject: Re: Accents bug ?
Next
From: Grant Edwards
Date:
Subject: FW: Errors when building jdbc dirver jar file