Re: Accents bug ?

On 24 Oct 2001 17:51:56 +0200, Denis Bucher wrote:
> You exactely have the same problem as I have.
> And my base is also UNICODE...

> Well, are you sure ? With *all* tools, that can be psql or pgdump_all,
> everything seems
> right, look at an extract of a dump :
> 6 6 PPN Nigiri mixte t t
> 7 7 PNS Nigiri saké t t
> 8 8 PNT Nigiri maguro t t
> 9 9 PNM Nigiri saké maguro t t
> 43 43 PSM Petit Nigiri maguro t t
> 44 44 PSS Petit Nigiri saké t t

Maybe you'll just have to force charset at connexion opening just like
this :
Connection conn =
DriverManager.getConnection("jdbc:postgresql://myDataBase?charSet=iso-8859-1",uid,pw);

You can force charSet to different values. There's a complete paragraph
on Postgresql doc on supported charsets.

Hope it would help.
--
Jean-Christophe ARNU
s/w developer
Paratronic France

Dans un premier temps, ayons l'esprit large et naviguons à la voile et
à la vapeur. Si la promiscuité entre les deux communautés devient
insupportable, il sera toujours temps d'organiser l'apartheid.
-+- PM in: Guide du Cabaliste Usenet - Bien séparer les enfilades -+-