Re: Accents bug ? - Mailing list pgsql-jdbc

From Jean-Christophe ARNU
Subject Re: Accents bug ?
Date
Msg-id 1004015061.3573.44.camel@ez
Whole thread Raw
In response to Re: Accents bug ?  (Denis Bucher <dbucher@niftycom.com>)
List 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 -+-


pgsql-jdbc by date:

Previous
From: "Dave Cramer"
Date:
Subject: Re: "No Suitable Driver"
Next
From: Mark Lillywhite
Date:
Subject: Re: [PATCHES] DatabaseMetadata patch