Message-ID: <3A75B4D6.6B05E96D@xythos.com>
Date: Mon, 29 Jan 2001 10:22:14 -0800
From: Barry Lind <barry@xythos.com>
MIME-Version: 1.0
To: Jean-Francois Burdet <Jean-Francois.Burdet@adm.unige.ch>
CC: pgsql-jdbc@postgresql.org
Subject: Re: [INTERFACES] jdbc: v7.1 bug (letter accent)
References: <3A754FD2.A0921E05@adm.unige.ch>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

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 &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 ?)
> 
> Thanks,
> 
> JF Burdet
> 
> My config is :
> - Mandrake Linux 7.1
> - JDK 1.3
> - Tomcat 3.2.1