Re: [INTERFACES] jdbc: v7.1 bug (letter accent)

From: Barry Lind <barry(at)xythos(dot)com>
To: Jean-Francois Burdet <Jean-Francois(dot)Burdet(at)adm(dot)unige(dot)ch>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [INTERFACES] jdbc: v7.1 bug (letter accent)
Date: 2001-01-29 18:22:14
Message-ID: 3A75B4D6.6B05E96D@xythos.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces pgsql-jdbc

What character set encoding is your database using? (select
getdatabaseencoding();)
My guess is that your database was created with the wrong character set
encoding.

thanks,
--Barry

Jean-Francois Burdet wrote:
>
> 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 &eacute; 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 ?)
>
> Thanks,
>
> JF Burdet
>
> My config is :
> - Mandrake Linux 7.1
> - JDK 1.3
> - Tomcat 3.2.1

In response to

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message djohn8 2001-01-29 23:21:21 Recent posting
Previous Message Wayne Johnson 2001-01-29 15:53:47 Postgresql and JDBC

Browse pgsql-jdbc by date

  From Date Subject
Next Message Richard Bullington-McGuire 2001-01-29 20:58:40 Re: Re: Patch for jdbc Makefile
Previous Message Tom Lane 2001-01-29 17:36:59 Re: Open 7.1 items