Re: Accents for TEXT

Le Wed, 27 Mar 2002 15:15:33 +0100
"Elisabeth Julg" <elisabeth(dot)julg(at)steria(dot)com> me disait que :

> 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.
Consider using jdbc:postgresql://localhost/Smp?charSet=ISO-8859-1 instead.

This works with my (French) database
--
Jean-Christophe ARNU
s/w developer
Paratronic France
Question: Comment s'écrit Jacoboni ?
Réponse: Jacoboni, pas Jacobini.
-+- fcol-faq in Guide du linuxien pervers - "Bien configurer son Jaco" -+-