Re: JDBC driver, PGSQL 7.3.2 and accents characters - Mailing list pgsql-jdbc

From Barry Lind
Subject Re: JDBC driver, PGSQL 7.3.2 and accents characters
Date
Msg-id 3E7B9DDC.4020005@xythos.com
Whole thread Raw
In response to Re: JDBC driver, PGSQL 7.3.2 and accents characters  (Davide Romanini <romaz@libero.it>)
List pgsql-jdbc

Davide Romanini wrote:
> You surely are right, but... my data is already stored in the database.
> And when I work with them with psql or the odbc driver (linking tables
> in M$ Access) my accents are there without any problem. Why the jdbc
> driver doesn't work while the others program all work?

Java uses UCS2 as its internal character set.  So jdbc must do a
character set translation for all string data.  In psql (and probably
odbc), by default no translation is needed.

--Barry



pgsql-jdbc by date:

Previous
From: Davide Romanini
Date:
Subject: Re: JDBC driver, PGSQL 7.3.2 and accents characters
Next
From: "Mario Rodriguez Villanea"
Date:
Subject: spanish characters in postgres