Skip site navigation (1) Skip section navigation (2)

Re: Accents for TEXT

From: Jean-Christophe ARNU (JX) <jc(dot)arnu(at)wanadoo(dot)fr>
To: <elisabeth(dot)julg(at)steria(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Accents for TEXT
Date: 2002-03-27 14:57:15
Message-ID: 20020327135715.11a07f0b.jc.arnu@wanadoo.fr (view raw or flat)
Thread:
Lists: pgsql-jdbc
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" -+- 

In response to

pgsql-jdbc by date

Next:From: Elisabeth JulgDate: 2002-03-27 15:05:52
Subject: Re: Accents for TEXT
Previous:From: tonyDate: 2002-03-27 14:40:13
Subject: Re: Accents for TEXT

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group