Accents for TEXT - Mailing list pgsql-jdbc

From Elisabeth Julg
Subject Accents for TEXT
Date
Msg-id KPEJIADGDLIFKJACKNIDAEEKCCAA.elisabeth.julg@steria.com
Whole thread Raw
Responses Re: Accents for TEXT
Re: Accents for TEXT
List 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





pgsql-jdbc by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: little error messages fix
Next
From: "Dave Cramer"
Date:
Subject: Re: Driver fails to connect