CSN wrote:
> I created a new database with encoding UTF8, connected
> using psql, and ensured the client encoding is also
> UTF8 (Unicode). But when I try to insert characters
> like 'é', I get this error:
>
> ERROR: invalid byte sequence for encoding "UNICODE":
> 0xe9
Something isn't UTF-8, possibly your terminal settings?
If you have a text-editor that lets you set character-encoding then you
can try feeding the query into psql from a file. If that works then it's
your terminal.
I always have endless trouble with this sort of stuff myself, so you're
not alone.
--
Richard Huxton
Archonet Ltd