Hiya,
I was 2 months ago using the sourceforge JDBC driver on WinNt as client and HP-UX as server (so PostgresQl) server. At time I had problems with the extented ASII set, all the characters were converted to "?". So I switched to the org.postgresql.Driver and problem seems to be solved.
Now 2 months later we have to go into production and the target OS is Debian Linux for client and server. And guess what I can see the same problem, all characters belonging to the extented set are converted to "?".
I have written a small testprogram, create one connection and tries to insert data with Java and JDBC. This seems not to work. But .... if I insert data with psql -h ... -f insertcommandfile.sql and look then in the database then there is no problem at all. Extented Characters are inserted. So I suppose the Db is correctly configured. (eg client-encoding and server encoding).
I have seen that ages ago the JDBC driver had problems with encoding but this was solved I thought.
I'm testing with this character: é, but also other characters has the same problem.
I need help .... Real help ...
Kind regards,
Thomas De Vos
IT Enterprise Ltd
Phone: 00 44 (0)127 650 5385
Mobile: 00 44 (0)777 990 7717
ThomasDeVos@it-enterprise.co.uk