Re: Inserting in psql - invalid byte sequence for encoding "UNICODE": 0xe9 - Mailing list pgsql-general

From Tom Lane
Subject Re: Inserting in psql - invalid byte sequence for encoding "UNICODE": 0xe9
Date
Msg-id 20401.1142435229@sss.pgh.pa.us
Whole thread Raw
In response to Inserting é in psql - invalid byte sequence for encoding "UNICODE": 0xe9  (CSN <cool_screen_name90001@yahoo.com>)
List pgsql-general
CSN <cool_screen_name90001@yahoo.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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Dumping rows into an array?
Next
From: TJ O'Donnell
Date:
Subject: Five reasons why you should never use PostgreSQL -- ever