You are definitely inputting ISO 8859-1 characters, not UTF-8. That's
the source of your problem.

> Tatsuo Ishii wrote:
> > 
> > > > Are you sure that you put the query in UTF-8 encoding?
> > >
> > > Yes :
> > >
> > > essai=> SHOW CLIENT_ENCODING;
> > > NOTICE:  Current client encoding is UNICODE
> > > SHOW VARIABLE
> > 
> > My point is whether you put the character in UTF-8 or not. Try:
> > 
> > $ echo 'e' > e.txt (e is actually e + accent)
> > $ od -x e.txt
> > 
> > and show me the result of "cat e.txt"
> 
> 
> $ echo 'é' > e.txt
> 
> $ cat e.txt
> é
> 
> $ od -x e.txt
> 0000000 0ae9
> 0000002

In response to

• Re: Problem with the accents at 2001-09-29 00:21:45 from Tatsuo Ishii

Responses

• Re: [GENERAL] Problem with the accents at 2001-10-03 01:01:16 from Tatsuo Ishii

pgsql-hackers by date

Next:	From: Tom Lane	Date: 2001-10-02 05:55:45
	Subject: Re: [HACKERS] CVS changes
Previous:	From: Sean Chittenden	Date: 2001-10-02 05:07:27
	Subject: Re: cvs problem

pgsql-general by date

Next:	From:	Date: 2001-10-02 06:06:27
	Subject: Problem with indices (?) in PostgreSQL 7.0.2
Previous:	From: David L. Collison	Date: 2001-10-02 04:16:43
	Subject: oleDB Support