Quoting Jean-Francois Burdet <Jean-Francois.Burdet@adm.unige.ch>:
Redirecting to the jdbc list:
> Hi,
>
> I'm doing some tests to migrate an PG7.0.2 database to an PG7.1beta3.
> This database contains letter with accent from french (like é in
> HTML or the word café).
>
> When using the postgresql.jar from pg7.0.2, rs.getString("name") gives
> corrects results (like 'café') , but
> when I move to the postgresql.jar compiled from PG7.1beta3 bundle
> letter
> with accent are converted to '?' (like 'caf?') ...
>
> Any one aware of this problem ? (and it's solution ?)
Have you set the database encoding? 7.1 is encoding aware so it's probably
stripping out the accents.
--
Peter Mount peter@retep.org.uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/