CSN <cool_screen_name90001(at)yahoo(dot)com> writes:
> 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
Whatever you're typing in is not actually sending UTF8 to psql.
You probably need to be fooling with the settings of xterm or
whatever window system you're working in.
regards, tom lane