Re: invalid byte sequence for encoding "UTF8": 0xab - Mailing list pgsql-general

From Tom Lane
Subject Re: invalid byte sequence for encoding "UTF8": 0xab
Date
Msg-id 3213.1244210271@sss.pgh.pa.us
Whole thread Raw
In response to invalid byte sequence for encoding "UTF8": 0xab  ("Grand, Mark D." <mgrand@emory.edu>)
Responses Re: invalid byte sequence for encoding "UTF8": 0xab
List pgsql-general
"Grand, Mark D." <mgrand@emory.edu> writes:
> ... I get this message:
> ERROR:  invalid byte sequence for encoding "UTF8": 0xab
> HINT:  This error can also happen if the byte sequence does not match the encoding expected by the server, which is
controlledby "client_encoding". 

> It is complaining about the '<' character.  I do not understand why.

The ASCII code for '<' is 0x3c, not 0xab.  I am not sure what you are
actually typing; although it's suggestive that the LATIN1 code 0xab
corresponds to a symbol that looks approximately like '<<'.  The most
likely bet is that you are typing the wrong thing and using a terminal
emulator that is not set to generate UTF8-encoded characters.  You
should try to make sure that client_encoding is set to match what your
keyboard actually generates.

            regards, tom lane

pgsql-general by date:

Previous
From: Rafal Pietrak
Date:
Subject: Re: sequences and RULEs
Next
From: David Fetter
Date:
Subject: Re: Move PGdata to a different drive