What character set encoding is your database using? (select
getdatabaseencoding();)
My guess is that your database was created with the wrong character set
encoding.
thanks,
--Barry
Jean-Francois Burdet wrote:
>
> 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 ?)
>
> Thanks,
>
> JF Burdet
>
> My config is :
> - Mandrake Linux 7.1
> - JDK 1.3
> - Tomcat 3.2.1