Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

Next:From: Dave CramerDate: 2001-10-25 14:18:01
Subject: Re: Code Fixes
Previous:From: Mark LillywhiteDate: 2001-10-25 01:18:57
Subject: Re: [PATCHES] DatabaseMetadata patch

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group