Re: Accents bug ?

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