Received: from mail.retep.org.uk ([216.126.85.184]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0U94oq98907 for ; Tue, 30 Jan 2001 04:04:50 -0500 (EST) (envelope-from peter@retep.org.uk) Received: (from nobody@localhost) by mail.retep.org.uk (8.11.1/8.11.1) id f0U94m198903; Tue, 30 Jan 2001 04:04:48 -0500 (EST) (envelope-from peter@retep.org.uk) X-Authentication-Warning: mail.retep.org.uk: nobody set sender to peter@retep.org.uk using -f To: Jean-Francois Burdet Subject: Re: [INTERFACES] jdbc: v7.1 bug (letter accent) Message-ID: <980845488.3a7683b084019@webmail.retep.org.uk> Date: Tue, 30 Jan 2001 04:04:48 -0500 (EST) From: Peter T Mount Cc: pgsql-jdbc@postgresql.org References: <3A754FD2.A0921E05@adm.unige.ch> In-Reply-To: <3A754FD2.A0921E05@adm.unige.ch> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: IMP/PHP IMAP webmail program 2.2.3 X-Archive-Number: 200101/90 X-Sequence-Number: 95 Quoting Jean-Francois Burdet : 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/