Re: [INTERFACES] jdbc: v7.1 bug (letter accent)

Quoting Jean-Francois Burdet <Jean-Francois(dot)Burdet(at)adm(dot)unige(dot)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 &eacute; 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(at)retep(dot)org(dot)uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/