Accents for TEXT

From: "Elisabeth Julg" <elisabeth(dot)julg(at)steria(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: Accents for TEXT
Date: 2002-03-27 14:15:33
Message-ID: KPEJIADGDLIFKJACKNIDAEEKCCAA.elisabeth.julg@steria.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,

I have problem with french accents like é, è, à ....

In my database (coding in LATIN1), I have a field as :
CREATE TABLE XX (Comment TEXT);

But, accents are transformed as "?" caracter in my HTML page (result of a
selection) !
If the field is a VARCHAR(50), it works well ?

Configuration :
- postgreSQL 7.2 (compile with
: --with-java --enable-multibyte=LATIN1 --enable=locale)
- Tomcat 4.0.2
- Mandrake 8.1,
- jdk1.3.1_02 : URL : jdbc:postgresql://localhost/Smp?charSet=LATIN1.

Have an idea wy or a solution ?

Thanks,

Elisabeth
France

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2002-03-27 14:29:32 Re: Driver fails to connect
Previous Message Bruce Momjian 2002-03-27 10:53:00 Re: little error messages fix