> > 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"
--
Tatsuo Ishii