From: Peter T Mount <peter@retep.org.uk>
To: Jean-Francois Burdet <Jean-Francois.Burdet@adm.unige.ch>
Cc: pgsql-jdbc@postgresql.org
Subject: Re: [INTERFACES] jdbc: v7.1 bug (letter accent)
Date: Tue, 30 Jan 2001 04:04:48 -0500 (EST)
Message-ID: <980845488.3a7683b084019@webmail.retep.org.uk> (raw)
In-Reply-To: <3A754FD2.A0921E05@adm.unige.ch>
References: <3A754FD2.A0921E05@adm.unige.ch>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: peter@retep.org.uk, Jean-Francois.Burdet@adm.unige.ch, pgsql-jdbc@postgresql.org
Subject: Re: [INTERFACES] jdbc: v7.1 bug (letter accent)
In-Reply-To: <980845488.3a7683b084019@webmail.retep.org.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox