Re: ERROR: invalid byte sequence for encoding "UTF8": 0x93 Error

Hi Michal,

Thanks for the info. However, the text that the user entered is all in English letters. I saw this error, when I restored my database with the pg_dump --insert option. That row didn't get inserted to the table. What's interesting about this problem is that when I manually entered the data to the database via psql, this record made it without any problems. It's still a mystery to me .....

Mary

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Michal Pawlikowski
Sent: Monday, March 08, 2010 4:38 AM
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] ERROR: invalid byte sequence for encoding "UTF8": 0x93 Error

On Mon, Mar 8, 2010 at 9:17 AM, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> wrote:
> Mary Y Wang wrote:
>> I got the following error and not sure how to fix it.
>> "psql:/tmp/030610dumpfile.txt:4369: ERROR:  invalid byte sequence for
>> encoding "UTF8": 0x93

look here:
http://www.depesz.com/index.php/2010/03/07/error-invalid-byte-sequence-for-encoding/

--
Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general