Re: Accents for TEXT

Le Wed, 27 Mar 2002 15:15:33 +0100
"Elisabeth Julg" <elisabeth.julg@steria.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" -+-