JDBC driver, PGSQL 7.3.2 and accents characters

From: Davide Romanini <romaz(at)libero(dot)it>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: JDBC driver, PGSQL 7.3.2 and accents characters
Date: 2003-03-19 09:35:08
Message-ID: 3E7839CC.90502@libero.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,

I've nice problems with the jdbc driver. I've tried with the jdbc2,
jdbc, latest stable and also development release.
I've a database in postgres with some varchar fields. The database is
SQL_ASCII as char encoding. In that varchar fields I've stored also
names with accents such è, à, ì etc... They work fine using the psql
program, and also linking tables to access through the odbc driver. But
when I try to use jdbc to connect to database my accents fail to load.
For example I have the string 'Forlì Sud'. When I try to
system.out.println this string catched by jdbc with rs.getString, I see
this string instead of the original one: 'Forl?ud'.
I've tried also to use different character sets in the connection url
like ISO-8859-1, UNICODE, WIN, SQL_ASCII but didn't change anything.

Please help me, because this bug makes java and jdbc pretty unusable to
connect pgsql databases.

Bye, Romaz

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2003-03-19 09:36:00 Re: Follow-up OpenOffice and Postgres 7.3.2
Previous Message Paul Sorenson 2003-03-19 08:35:03 auto generated keys