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