Re: Accents bug ?

From: Jean-Christophe ARNU <jc(dot)arnu(at)wanadoo(dot)fr>
To: Denis Bucher <dbucher(at)niftycom(dot)com>
Cc: Knut Forkalsrud <kforkalsrud(at)cj(dot)com>, PGSQL-JDBC <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Accents bug ?
Date: 2001-10-25 13:04:19
Message-ID: 1004015061.3573.44.camel@ez
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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 -+-

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2001-10-25 14:18:01 Re: Code Fixes
Previous Message Mark Lillywhite 2001-10-25 01:18:57 Re: [PATCHES] DatabaseMetadata patch