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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
