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